Category Archives: Uncategorized

PCC-00002: Invalid syntax at column number in line number of file string

oracle

PCC-00002: Invalid syntax at column number in line number of file string
Cause: There is a syntax error in an EXEC statement or the statement is not properly terminated.
Action: Correct the syntax of the EXEC statement. If the error occurred at the end of the input file, check that the last EXEC statement is properly terminated.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PCC-00001: Unable to open file string

oracle

PCC-00001: Unable to open file string
Cause: The precompiler was unable to open a temporary file for internal use. There might be insufficient disk space, too many open files, or read-only protection on the output directory.
Action: Check that there is enough disk space, that the limit for open files is set high enough (check with the system manager) and that protection on the directory allows opening a file for writing.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00546: SELF may not be declared as a REF parameter

oracle

PLS-00546: SELF may not be declared as a REF parameter 
Cause: SELF was declared as a REF parameter to a member function or procedure. SELF is not supported as a REF. 
Action: Redeclare SELF as a value parameter. 

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00543 a PLSQL Table may not contain a nested table type or VARRAY

oracle

PLS-00543 a PLSQL Table may not contain a nested table type or VARRAY
Cause: An attempt was made to define a PL/SQL table that contained a (possibly deeply) nested table type or VARRAY. Nested collection types are not supported.
Action: Remove the nested table type or VARRAY from the table. Then retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00542: CLOB and NCLOB cannot use varying-width character sets in the server

oracle

PLS-00542: CLOB and NCLOB cannot use varying-width character sets in the server
Cause: A server type is being created with an embedded CLOB or NCLOB attribute which uses a varying-width character set.
Action: Use VARCHAR2 instead of CLOB, or use a fixed-width character set.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00541: size or length specified is too large

oracle

PLS-00541: size or length specified is too large
Cause: A length or size that is too large was specified for a data item.
Action: Specify a smaller value and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00540: object not supported in this context

oracle

PLS-00540: object not supported in this context
Cause: An object was declared inside a local scope (Function, Procedure, or anonymous block), or in a package scope which is not supported.
Action: Declare the type in a global or data base scope.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00539: subprogram ‘string’ is declared in an object type body and must be defined in the object type specification

oracle

PLS-00539: subprogram 'string' is declared in an object type body and must be defined in the object type specification
Cause: The specified subprogram is declared in an object type's body, but is not defined in the object type's specification. Notice cursor bodies can exist without a specification.
Action: Define the subprogram in the object type's specification, or remove the declaration from the body.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00538: subprogram or cursor ‘string’ is declared in an object type specification and must be defined in the object type body

oracle

PLS-00538: subprogram or cursor 'string' is declared in an object type specification and must be defined in the object type body
Cause: The specified subprogram is declared in an object type's specification, but is not defined in the object type body.
Action: Define the subprogram in the object type body, or remove the declaration from the specification.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00537: A VARRAY must have a positive limit

oracle

PLS-00537: A VARRAY must have a positive limit
Cause: A VARRAY type was declared with a non-positive limit, for example VARRAY(0).
Action: Declare the VARRAY with a positive limit and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/