Category Archives: PLS Database Error Messages

PLS-00151: Expression or Variable is an illegal type to PLS/QL: string

oracle

PLS-00151: Expression or Variable is an illegal type to PLS/QL: string
Cause: A type was used which does not belong PL/SQL. This type can only be referenced in CREATE TYPE statements, and is a non-queryable data type.
Action: Use a different type and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00150: found: string but expected : INTEGER

oracle

PLS-00150: found: string but expected : INTEGER
Cause: This error happens in the creation of a PL/SQL external type: [SIGNED | UNSIGNED] BINARY INTEGER (precision). It may be referenced only in a create type statement. Such types are non-queryable. Something other than 'INTEGER' was supplied.
Action: Use a different type and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00148: Only 1 pragma of this type is allowed per subprogram

oracle

PLS-00148: Only 1 pragma of this type is allowed per subprogram
Cause: The subprogram was found to have two PRAGMA RESTRICT_REFERENCES.
Action: Remove one of the PRAGMA RESTRICT_REFERENCES.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00147: LIBRARY file specification string is empty

oracle

PLS-00147: LIBRARY file specification string is empty
Cause: A zero-length string was found for the LIBRARY file specification.
Action: Specify a non-zero length string for the LIBRARY file specification.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression

oracle

PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression
Cause: The subprogram was found to have two external TRUSTED/UNTRUSTED specifications.
Action: Remove one of the external TRUSTED/UNTRUSTED specifications.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00145: duplicate external WITH CONTEXT specification in subprogram expression

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00144: duplicate external CALLING STANDARD specification in subprogram expression

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00143: duplicate external LANGUAGE specification in subprogram expression

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00142: duplicate external PARAMETER list specification in subprogram expression

oracle

PLS-00142: duplicate external PARAMETER list specification in subprogram expression
Cause: The subprogram was found to have two external PARAMETER STYLE specifications.
Action: Remove one of the external PARAMETER STYLE specifications.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00141: duplicate external PARAMETER STYLE specification in subprogram expression

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/