Errores pls

Errores pls mas frecuentes

PLS-00619: the first operand in the NULLIF expression must not be NULL

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

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

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

PLS-00241: invalid external type specification for SQLSTATE

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

PLS-00419: reference to remote attribute not permitted

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

PLS-00161: Pragma string expects 3rd argument to be an identifier or a string literal

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

PLS-01414: Use of qualified expression here

PLS-01424: Non-ANSI order of clauses

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

PLS-00638: cannot overload MAP method

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

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

PLS-01507: DROP is non-ANSI

PLS-00508: The expression in a RETURN statement cannot be a type

PLS-01421: FOR UPDATE clause

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

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

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

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

PLS-01903: : non-integer error number

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

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

PLS-00397: Type mismatch in arguments to IN

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

PLS-01464: VARIANCE is not a standard set function

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

PLS-01402: Use of quoted identifier

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

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

PLS-01415: Use of aggregate value here

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

PLS-01401: Identifier over 18 characters long

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

PLS-01701: Illegal syntax in ROLLBACK WORK statement

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

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

PLS-01715: ANSI does not accept SAVEPOINTs

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

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

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

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

PLS-00236: Invalid external type specification for string.

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

PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

PLS-01900: : character to number conversion error

PLS-01409: Use of 'PRIOR_' token