All posts by mpbod

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-01913: instance must be of type ‘string’ or one of its subtypes

oracle

PLS-01913: instance must be of type 'string' or one of its subtypes
Cause: The run-time type of the instance is the not declared type or one of its subtypes. That is, TREAT(supertype AS subtype) fails.
Action: Catch the exception.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01912: instance must be of type ‘string’

oracle

PLS-01912: instance must be of type 'string'
Cause: The run-time type of the instance is not the declared type. That is, the return value of a user defined constructor is wrong.
Action: Return the correct type.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01911: associative array key violates its type constraints

oracle

PLS-01911: associative array key violates its type constraints
Cause: The key value of an element being inserted into an associative array violates the key type constraints.
Action: Relax the constraints if the key value is meant to be acceptable. Otherwise, apply a valid key value when inserting an element.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01910: associative array shape is not consistent with session parameters

oracle

PLS-01910: associative array shape is not consistent with session parameters
Cause: NLS parameters affecting comparison of keys have been altered dynamically. The associative array's index is invalid.
Action: Avoid using associative arrays with string keys in applications which require frequent changes of NLS_COMP or NLS_SORT.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01909: cannot assign supertype instance to subtype

oracle

PLS-01909: cannot assign supertype instance to subtype
Cause: An attempt was made to assign or copy a supertype instance to a container (destination) that can only hold a subtype instance.
Action: Make sure the runtime type of the source of the assignment or copy is the same type as the destination or is a subtype of the destination type.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01908: RETURNING INTO buffer too small

oracle

PLS-01908: RETURNING INTO buffer too small
Cause: PL/SQL determined that a server side DML with a RETURNING INTO clause does not use a buffer that is large enough to hold the data being returned.
Action: Increase the size of the RETURNING INTO clause buffer.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01907: number precision too large

oracle

PLS-01907: number precision too large
Cause: The number begin copied or assigned had too many digits to the left of the decimal and did not fit into its destination. In other words, there is a number precision mismatch. This error may also occur if, for example, an attempt is made to assign a character string to a number, as demonstrated below. 

a varchar2(4); 

b number(1,1); 

a := '10.1'; 

b := a;
Action: First, check explicit number precision value mismatches. If none are found, then consider implicit conversions of other types to numbers, including conversions performed during binds.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01906: raw variable length too long

oracle

PLS-01906: raw variable length too long
Cause: The length of a raw variable being copied or assigned was too long to fit into its destination.
Action: Make sure the raw variable length is correct.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/