PLS-00400 TO PLS-00499

oracle

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

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

PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

PLS-00403: expression ‘string’ cannot be used as an INTO-target of a SELECT/FETCH statement

PLS-00404: cursor ‘string’ must be declared with FOR UPDATE to use with CURRENT OF

PLS-00405: subquery not allowed in this context

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

PLS-00407: ‘*’ not allowed here; a list of columns is required

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

PLS-00409: duplicate variable ‘string’ in INTO list is not permitted

PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted

PLS-00411: Number of values in aggregate and in subquery don’t match

PLS-00412: list of values not allowed as argument to this function or procedure

PLS-00413: identifier in CURRENT OF clause is not a cursor name

PLS-00414: no column ‘string’ in table

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

PLS-00416: The third argument of DECODE cannot be NULL

PLS-00417: unable to resolve “string” as a column

PLS-00418: array bind type must match PL/SQL table row type

PLS-00419: reference to remote attribute not permitted

PLS-00420: can’t call builtin routines remotely

PLS-00421: synonym definitions nested too deeply; possible loop in synonyms

PLS-00422: no PL/SQL translation for the bindtype given for this bind variable

PLS-00423: ORDER BY item must be the number of a SELECT-list expression

PLS-00424: RPC defaults cannot include Package State

PLS-00425: in SQL, function argument and return types must be SQL type

PLS-00426: cursor variable OUT parameter ‘string’ cannot be FETCH’ed or CLOSE’d

PLS-00427: RPC defaults cannot use builtins when versions of STANDARD differ

PLS-00428: an INTO clause is expected in this SELECT statement

PLS-00429: unsupported feature with RETURNING clause

PLS-00430: FORALL iteration variable string is not allowed in this context

PLS-00431: bulk SQL attributes must use a single index

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

PLS-00433: inconsistent package STANDARD

PLS-00434: record field has unsupported type: “string”

PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL

PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records

PLS-00437: FORALL bulk index cannot be used in string clause

PLS-00438: value in LIMIT clause: ‘string’ use is invalid

PLS-00439: A LIMIT clause must be used within a BULK FETCH

PLS-00450: a variable of this private type cannot be declared here

PLS-00452: Subprogram ‘string’ violates its associated pragma

PLS-00453: remote operations not permitted on object tables or user-defined type columns

PLS-00454: with a returning into clause, the table expression cannot be remote or a subquery

PLS-00455: cursor ‘string’ cannot be used in dynamic SQL OPEN statement

PLS-00456: item ‘string’ is not a cursor

PLS-00457: expressions have to be of SQL types

PLS-00458: subprogram ‘string’ cannot be called from a REPEATABLE subprogram

PLS-00459: this feature is not allowed in REPEATABLE subprogram

PLS-00460: REPEATABLE subprogram ‘string’ has to be RNDS, WNDS, RNPS, and WNPS

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

PLS-00462: nested subprogram ‘string’ has to be REPEATABLE

PLS-00483: exception ‘string’ may appear in at most one exception handler in this block

PLS-00484: redundant exceptions ‘string’ and ‘string’ must appear in same exception handler

PLS-00485: in exception handler, ‘string’ must be an exception name

PLS-00486: select list cannot be enclosed in parentheses

PLS-00487: Invalid reference to variable ‘string’

PLS-00488: invalid variable declaration: object ‘string’ must be a type or subtype

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

PLS-00490: illegal statement

PLS-00491: numeric literal required

PLS-00492: variable or constant initialization may not refer to functions declared in the same package

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

PLS-00494: coercion into multiple record targets not supported

PLS-00495: too many columns in SELECT…INTO statement after bursting record targets

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

PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list

PLS-00498: illegal use of a type before its declaration

PLS-00499: coercion into collection of records not supported

Back to ALL PLS-CODE TRACKS

Back to ALL PLS-CODE LIST

https://support.oracle.com/

http://www.oracle.com/

Translate »