Errores PLS

Errores PLS mas frecuentes

PLS-00224: object 'string' must be of type function or array to be used this way

PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements

PLS-00654: PARTITION/ORDER/CLUSTER BY is only allowed for with PARALLEL_ENABLE

PLS-00367: a RAISE statement with no exception name must be inside an exception handler

PLS-00710: PRAGMA AUTONOMOUS_TRANS*Action cannot be declared here

PLS-01904: : NULL index table key value

PLS-00122: string as separator is allowed only with specific built-in functions

PLS-00396: INSERT statement's subquery yields wrong number of columns

PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands

PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor

PLS-00629: PIPE statement cannot be used in non-pipelined functions

PLS-00395: wrong number of values in VALUES clause of INSERT statement

PLS-00701: illegal ORACLE error number string for PRAGMA EXCEPTION_INIT

PLS-00206: \%TYPE must be applied to a variable, column, field or attribute, not to "string"

PLS-00132: Pragma RESTRICT_REFERENCES does not support string

PLS-00361: IN cursor 'string' cannot be OPEN'ed

PLS-00712: illegal option for subprogram string

PLS-00362: invalid cursor return type; 'string' must be a record type

PLS-00526: A MAP or ORDER function is required for comparing objects in PL/SQL.

PLS-00540: object not supported in this context.

PLS-00561: character set mismatch on value for parameter 'string'

PLS-00408: duplicate column 'string' not permitted in INSERT or UPDATE

PLS-00652: aggregate functions should have exactly one argument

PLS-00124: name of exception expected for first arg in exception_init pragma

PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

PLS-00496: too few columns in SELECT...INTO statement after bursting record targets

PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

PLS-00633: RETURN statement in a pipelined function cannot contain an expression

PLS-00125: type name expected

PLS-00376: illegal EXIT statement; it must appear inside a loop

PLS-00129: Pragma INTERFACE only supports C as its first argument

PLS-00102: parser stack overflow because nesting is too deep

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

PLS-00235: the external type is not appropriate for the parameter

PLS-00121: only the set function COUNT may take * as an argument

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

PLS-00527: MAP or ORDER functions require a PRAGMA RESTRICT_REFERENCES specifying :WNDS,WNPS,RNPS,RNDS.

PLS-00255: CALL Specification parameters cannot have default values

PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

PLS-00370: OTHERS handler must be last among the exception handlers of a block

PLS-00383: type mismatch found at 'string' inside an IN or NOT IN clause

PLS-00493: invalid reference to a server-side object or function in a local context

PLS-00131: Pragma string expects 2nd argument to be a procedure

PLS-00400: different number of columns between cursor SELECT statement and return value

PLS-00110: bind variable 'string' not allowed in this context

PLS-00105: at most one forward declaration of type 'string' is permitted

PLS-00112: end-of-line in quoted identifier

PLS-00513: PL/SQL function called from SQL must return value of legal SQL type

PLS-00135: Pragma string expects 3rd argument to be an identifier, string or numeric literal

PLS-00657: Implementation restriction: bulk SQL with associative arrays with VARCHAR2 key is not supported.