Category Archives: PLS Database Error Messages

PLS-00303: qualifier ‘string’ must be declared

oracle

PLS-00303: qualifier 'string' must be declared
Cause: In a name such as "A.B", "A" is the qualifier, and "B" is a component of the qualifier. This error occurs when no declaration for the qualifier is found. The qualifier might be misspelled, its declaration might be faulty, or the declaration might be placed incorrectly in the block structure.
Action: Check the spelling and declaration of the qualifier. Also confirm that the declaration is placed correctly in the block structure.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00302: component ‘string’ must be declared

oracle

PLS-00302: component 'string' must be declared
Cause: In a reference to a component (for example, in the name "A.B", "B" is a component of "A"), the component has not been declared. The component might be misspelled, its declaration might be faulty, or the declaration might be placed incorrectly in the block structure.
Action: Check the spelling and declaration of the component. Also confirm that the declaration is placed correctly in the block structure.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00261: Java CALL Specification not yet allowed as a method in an object type

oracle

PLS-00261: Java CALL Specification not yet allowed as a method in an object type
Cause: A call specification declaring that an implementation is in Java has been found for a method of an object or opaque type. This usage is not yet supported.
Action: Implement the method using a language other than Java. A PL/SQL method implementation is permitted to call to Java through a call specification provided as a schema-level procedure or in a package; such a call specification can only target a static Java method, however.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00260: Datetime/Interval constraints must be in range (0 .. 9)

oracle

PLS-00260: Datetime/Interval constraints must be in range (0 .. 9)
Cause: A Datetime/Interval variable or attribute was declared with a constraint outside the legal range.
Action: Change the illegal constraint.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00259: rights model (AUTHID) must be specified

oracle

PLS-00259: rights model (AUTHID) must be specified
Cause: It is mandatory to specify the rights model if a PL/SQL PROCEDURE, FUNCTION, PACKAGE OR TYPE HAS CALL-Specifications.
Action: Add the AUTHID clause indicating the rights model.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00258: constrained datatypes disallowed in CALL Specifications

oracle

PLS-00258: constrained datatypes disallowed in CALL Specifications
Cause: A call specification for C or Java cannot have constraints on the PL/SQL formal parameter types. PL/SQL types which have constraints are NATURAL, NATURALN, POSITIVE, POSITIVEN, SIGNTYPE, INTEGER, INT, SMALLINT, DECIMAL, NUMERIC, DEC. This includes NOT NULL constraints from POSITIVEN, NATURALN.
Action: Use the unconstrained type for that PL/SQL formal declaration that is, NUMBER, BINARY_INTEGER or PLS_INTEGER

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00257: illegal use of EXTERNAL clause in a TYPE or PACKAGE specification

oracle

PLS-00257: illegal use of EXTERNAL clause in a TYPE or PACKAGE specification
Cause: An EXTERNAL Clause was detected in a TYPE Specification or a PACKAGE specification.
Action: Remove the EXTERNAL Clause and use the new CALL Specification syntax.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00256: string is not a valid external library

oracle

PLS-00256: string is not a valid external library
Cause: The supplied external library name in the external clause is not a valid alias library.
Action: Provide the name of a valid alias library that has been previously declared.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00255: CALL Specification parameters cannot have default values

oracle

PLS-00255: CALL Specification parameters cannot have default values
Cause: CALL Specification formal parameters default values are disallowed.
Action: Remove the default values in the formal parameter list (specification or body) and compile again.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00254: OUT and IN/OUT modes cannot be used in this context

oracle

PLS-00254: OUT and IN/OUT modes cannot be used in this context
Cause: Actual parameter mode (OUT, or IN/OUT) is not used properly in USING clause. For USING clause in an OPEN statement, only IN mode is allowed.
Action: Change the parameter mode in the USING clause to an appropriate mode.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/