Errores PLS

Errores PLS mas frecuentes

PLS-00572: improper constraint form used

PLS-00413: identifier in CURRENT OF clause is not a cursor name

PLS-00153: A string type may only be used as an object type attribute.

PLS-00207: identifier 'string', applied to implicit cursor SQL, is not a legal cursor attribute

PLS-00612: Number of attributes do not match in SET clause

PLS-00708: Pragma string must be declared in a package specification

PLS-00658: constructor method name must match type name

PLS-00570: different number of columns in the multiset and cast expressions

PLS-00627: 'string' must be a strongly typed ref cursor

PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements

PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function

PLS-00393: wrong number of columns in SELECT...INTO statement

PLS-00660: SELF parameter of constructor method must be IN OUT

PLS-00160: AUTHID must specify CURRENT_USER or DEFINER

PLS-00303: qualifier 'string' must be declared

PLS-00392: Type mismatch in arguments to BETWEEN

PLS-00910: insufficient privilege to inherit from type string

PLS-00167: keyword BULK is used in a wrong context

PLS-00438: value in LIMIT clause: 'string' use is invalid

PLS-00491: numeric literal required

PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema

PLS-00407: '*' not allowed here; a list of columns is required

PLS-00533: Tables of non_queryable types are not supported.

PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter

PLS-00213: package STANDARD not accessible

PLS-00258: constrained datatypes disallowed in CALL Specifications

PLS-01712: ANSI does not allow bind variables as INDICATORS

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

PLS-00484: redundant exceptions 'string' and 'string' must appear in same exception handler

PLS-00607: SQLJ Object Types can have only SQLJ Types as its supertype or subtype

PLS-00655: only functions can be declared as PIPELINED

PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

PLS-01403: Comment delimiters /* */

PLS-00711: PRAGMA AUTONOMOUS_TRANS*Action cannot be declared twice

PLS-00996: out of memory

PLS-00437: FORALL bulk index cannot be used in string clause

PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

PLS-00705: exception 'string' used in expression requiring return type

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

PLS-00411: Number of values in aggregate and in subquery don't match

PLS-00483: exception 'string' may appear in at most one exception handler in this block

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

PLS-00244: Multiple declarations in foreign function formal parameter list

PLS-00226: package 'string' used as variable reference

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

PLS-00140: duplicate external LIBRARY specification in subprogram expression

PLS-00995: unhandled exception # string

PLS-00365: 'string' is an OUT parameter and cannot be read

PLS-00389: table, view or alias name "string" not allowed in this context

PLS-00318: type "string" is malformed because it is a non-REF mutually recursive type