Errores PLS

Errores PLS mas frecuentes

PLS-01410: Use of 'MOD' token

PLS-00523: ORDER methods must return an INTEGER.

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

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

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

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

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

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

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

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

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

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

PLS-01469: ANSI standard does not permit records

PLS-00168: duplicate modifier specification 'string'

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

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

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

PLS-00217: NUMBER scale constraint must be in range (-84 .. 127)

PLS-01407: One of the identifiers CHAR, CHARACTER, or INTEGER has been redefined by the programmer

PLS-01421: FOR UPDATE clause

PLS-01507: DROP is non-ANSI

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

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

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

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

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

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

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

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

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

PLS-01423: Subquery on right-hand-side in set clause

PLS-01414: Use of qualified expression here

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

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-01703: Cursor name in CLOSE statment must be of length 1

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

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

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

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

PLS-01503: The expression in a SET clause must not include a set function

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

PLS-00541: size or length specified is too large.

PLS-01408: Use of '&' token

PLS-01456: Name length cannot exceed 3.

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

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

PLS-01415: Use of aggregate value here

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