Errores PLS

Errores PLS mas frecuentes

PLS-00634: type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE

PLS-00658: constructor method name must match type name

PLS-00126: selector ALL is not allowed

PLS-00589: no attributes found in object type "string"

PLS-00115: this PRAGMA must follow the declaration of 'string'

PLS-00990: Index Tables of Cursor Variables are disallowed

PLS-00572: improper constraint form used

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

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

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

PLS-00392: Type mismatch in arguments to BETWEEN

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

PLS-00491: numeric literal required

PLS-00303: qualifier 'string' must be declared

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

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

PLS-00258: constrained datatypes disallowed in CALL Specifications

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

PLS-00910: insufficient privilege to inherit from type string

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

PLS-00160: AUTHID must specify CURRENT_USER or DEFINER

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

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

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

PLS-00118: Duplicate group-by clause in table expression

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

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

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

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

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

PLS-00213: package STANDARD not accessible

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

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

PLS-00655: only functions can be declared as PIPELINED

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

PLS-01403: Comment delimiters /* */

PLS-00140: duplicate external LIBRARY specification in subprogram expression

PLS-00154: An object type may have only 1 MAP or 1 ORDER method.

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

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

PLS-00995: unhandled exception # string

PLS-00996: out of memory

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

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

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

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

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

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

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

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