Errores PLS

Errores PLS mas frecuentes

PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field

PLS-00528: The parameters to an ORDER function must have IN mode

PLS-01454: No operator may be used with values of data type CHAR

PLS-00663: the NEW keyword is not allowed in this context

PLS-00901: the data type of column 'string' of table 'string' is not supported

PLS-00608: the value of the USING clause must match that of the supertype

PLS-00662: Non-external object types containing external mapped attributes are not allowed

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

PLS-00401: different column types between cursor SELECT statement and return value found at 'string'

PLS-00415: 'string' is an OUT parameter and cannot appear in a function

PLS-00571: method access through data base link not yet supported on client side

PLS-00377: internal type PLS_INTEGER is not included in this release of PL/SQL

PLS-00550: character set specification is not allowed for this type

PLS-00649: method "string" can be overridden only once per object type

PLS-00168: duplicate modifier specification 'string'

PLS-01501: Options in CREATE TABLE statement is non-ANSI.

PLS-00997: no cursor return types allowed in this beta version

PLS-01408: Use of '&' token

PLS-01913: instance must be of type 'string' or one of its subtypes

PLS-00381: type mismatch found at 'string' between column and variable in subquery or INSERT

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

PLS-00212: could not obtain enough memory to compile CASE statement

PLS-00515: The type of the REF INTO variable 'string' must be REF to the table's type

PLS-00717: method 'string' does not have matching signature among existing methods

PLS-01469: ANSI standard does not permit records

PLS-01703: Cursor name in CLOSE statment must be of length 1

PLS-00251: RETURN, for actual function return, must be last in the parameters clause

PLS-01451: The data types of these value_expressions must be comparable

PLS-00332: "string" is not a valid prefix for a qualified name

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

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

PLS-00582: attribute declarations are not allowed in opaque types

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

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

PLS-01507: DROP is non-ANSI

PLS-00406: length of SELECT list in subquery must match number of assignment targets

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

PLS-00624: USING clause must be used with either aggregate or pipelined functions

PLS-01421: FOR UPDATE clause

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

PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY

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-01503: The expression in a SET clause must not include a set function

PLS-00333: "string" must match an object-table alias in this context

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

PLS-01414: Use of qualified expression here

PLS-01456: Name length cannot exceed 3.