Errores PLS

Errores PLS mas frecuentes

PLS-00359: assignment target in 'string' must have components

PLS-00461: mismatch REPEATABLE information between specification and body of 'string'

PLS-00514: INSERT statement with REF INTO clause requires a typed table

PLS-00709: pragma string must be declared in package specification and body

PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses

PLS-00380: functions and procedures are not included in this release of PL/SQL

PLS-00419: reference to remote attribute not permitted

PLS-00610: ROW can be used only once in SET clause of UPDATE statement

PLS-01414: Use of qualified expression here

PLS-00374: illegal EXIT statement; it must appear inside the loop labeled 'string'

PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

PLS-01424: Non-ANSI order of clauses

PLS-01504: Use of AS phase in CREATE TABLE statement is non_ANSI

PLS-00638: cannot overload MAP method

PLS-00516: Type mismatch between object table and value 'string' in INSERT statement.

PLS-00648: type of supertype attribute "string" can not be a subtype or reference to a subtype in this release

PLS-01458: The set clause in an UPDATE statement requires a column name of length 1

PLS-00397: Type mismatch in arguments to IN

PLS-00621: at least one operand in the COALESCE expression must not be NULL

PLS-01405: Under ANSI's grammar, numeric data represented in exponent notationmust use an uppercase E

PLS-01473: Use <> instead of != or ~=

PLS-01715: ANSI does not accept SAVEPOINTs

PLS-00219: label 'string' reference is out of scope

PLS-01701: Illegal syntax in ROLLBACK WORK statement

PLS-00489: invalid table reference: 'string' must be a column in this expression

PLS-00585: declared support library for opaque type is not a library

PLS-00601: partition extended object names may only be used with tables

PLS-01406: An identifier has been found that is considered a keyword in ANSI's grammar but not in PL/SQL's

PLS-01502: Constraint name and constraint status are non-ANSI.

PLS-00600: SAMPLE cannot be applied to a remote object

PLS-01507: DROP is non-ANSI

PLS-00546: SELF may not be declared as a REF parameter.

PLS-01418: Subquery cannot include set operators in ANSI's grammar

PLS-01402: Use of quoted identifier

PLS-01470: The escape character in the like-predicate must be a literal or a variable of type CHAR

PLS-01900: : character to number conversion error

PLS-01415: Use of aggregate value here

PLS-01421: FOR UPDATE clause

PLS-01714: ANSI expects a column name not a literal value here

PLS-01455: The predicates IS NULL and IS NOT NULL are defined only for column specifications

PLS-00606: cursor subquery is not supported on client side in this release

PLS-01464: VARIANCE is not a standard set function

PLS-00623: FLOAT precision constraint must be between 1 and 126

PLS-01401: Identifier over 18 characters long

PLS-01453: This procedure is not part of the ANSI standard

PLS-01452: This function is not part of the ANSI standard

PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

PLS-00632: NOT INSTANTIABLE method cannot have a body