Category Archives: PLS Database Error Messages

PLS-00140: duplicate external LIBRARY specification in subprogram expression

oracle

PLS-00140: duplicate external LIBRARY specification in subprogram expression
Cause: The subprogram was found to have two external LIBRARY specifications.
Action: Remove one of the external LIBRARY specifications.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00139: duplicate external NAME specification in subprogram expression

oracle

PLS-00139: duplicate external NAME specification in subprogram expression
Cause: The subprogram was found to have two external NAME specifications.
Action: Remove one of the external NAME specifications.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00138: Precision for a binary type must be one of 8, 16, or 32

oracle

PLS-00138: Precision for a binary type must be one of 8, 16, or 32
Cause: Invalid precision was specified for a signed or unsigned binary type.
Action: Specify precision as one of 8, 16, or 32.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00135: Pragma string expects 3rd argument to be an identifier, string or numeric literal

oracle

PLS-00135: Pragma string expects 3rd argument to be an identifier, string or numeric literal
Cause: The third argument (actual parameter) passed to the named pragma (compiler directive) was not an identifier or string literal, as required. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters).
Action: Check the spelling of the third parameter, and make sure the proper syntax was used.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00134: Pragma string expects 2nd argument to be an identifier or string-literal

oracle

PLS-00134: Pragma string expects 2nd argument to be an identifier or string-literal
Cause: The second argument (actual parameter) passed to the named pragma (compiler directive) was not an identifier or string literal, as required. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters).
Action: Check the spelling of the second parameter, and make sure the proper syntax was used.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00133: Pragma string expects 1st argument to be an identifier or string-literal

oracle

PLS-00133: Pragma string expects 1st argument to be an identifier or string-literal 
Cause: The first argument (actual parameter) passed to the named pragma (compiler directive) was not an identifier or string literal, as required. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters). 
Action: Check the spelling of the first parameter, and make sure the proper syntax was used. 

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00132: Pragma RESTRICT_REFERENCES does not support string

oracle

PLS-00132: Pragma RESTRICT_REFERENCES does not support string
Cause: One of the parameters passed to pragma RESTRICT_REFERENCES was not among the following, as required: WNDS, WNPS, RNDS, RNPS. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters)
Action: Check the spelling of all the parameters, and make sure the proper syntax was used.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00131: Pragma string expects 2nd argument to be a procedure

oracle

PLS-00131: Pragma string expects 2nd argument to be a procedure
Cause: The second argument (actual parameter) passed to the named pragma (compiler directive) was not the name of a procedure, as required. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters).
Action: Check the spelling of the second parameter, and make sure the proper syntax was used.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor
Cause: 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).
Action: Check the spelling of the first parameter, and make sure the proper syntax was used.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00129: Pragma INTERFACE only supports C as its first argument

oracle

PLS-00129: Pragma INTERFACE only supports C as its first argument
Cause: The first parameter passed to pragma INTERFACE specified a host language other than C. Currently, C is the only host language supported. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters).
Action: Check the spelling of the first parameter, which should be C, and make sure the proper syntax was used.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/