How to fix the Oracle error PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor?

In this post, you’ll learn more about the Oracle ErrorPLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor

Reason for the Error PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor

The first argument (actual parameter) passed to the named pragma (compiler directive) was not the name of a subprogram, package, or cursor, as required. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters).

How to fix the Error PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor ?

You can fix this error in Oracle by following the below steps

Check the spelling of the first parameter, and make sure the proper syntax was used.