ORA-06568 obsolete ICD procedure called
Description:
ORA-06568 obsolete ICD procedure called
Cause:
An obsolete ICD procedure was called by a PL/SQL program. The PL/SQL program was probably written for an earlier release of RDBMS.
Error List
Error List for the ‘ORA-04100 to ORA-07499’ Category
ORA-06569 Collection bound by bind_array contains no elements
Description:
ORA-06569 Collection bound by bind_array contains no elements
Cause:
A collection with zero elements was bound to a bind variable in a call to procedure BIND_ARRAY in the package DBMS_SQL. In order to execute a bind of a collection, the collection must contain at least one element. If no elements are present, at execute time, there will be no value for this bind and the statement is meaningless.
ORA-06570 shared pool object does not exist, cannot be pinned
Description:
ORA-06570 shared pool object does not exist, cannot be pinned
Cause:
The specified shared pool shared cursor could not be found, therefore it cannot be pinned.
ORA-06571 Function string does not guarantee not to update database
Description:
ORA-06571 Function string does not guarantee not to update database
Cause:
One of the following:
- A SQL statement references a packaged, PL/SQL function that does not contain a pragma that prevents the database from being updated.
- A SQL statement references a standalone, PL/SQL function that contains an instruction to update the database.
Action: If the referenced function is a packaged, PL/SQL function, re-create the PL/SQL function with the required pragma; be certain to include the ‘Write No Database State’ (WNDS) argument in the argument list of the pragma. If the referenced function is standalone, PL/SQL function, do not use the function.
ORA-06573 Function string modifies package state, cannot be used here
Description:
ORA-06573 Function string modifies package state, cannot be used here
Cause:
One of the following:
- A SQL statement references a packaged, PL/SQL function that does not contain a pragma containing the ‘Write no Package State’ (WNPS).
- A SQL statement references a standalone, PL/SQL function that modifies a package state. A standalone, PL/SQL function referenced by a SQL statement cannot modify a package state.
Action: If the function is a packaged, PL/SQL function: Re-create the function and include a pragma containing the ‘Write no Package State’ (WNPS). If the function is standalone PL/SQL function, delete the function from the SQL statement.
ORA-06575 Package or function string is in an invalid state
Description:
ORA-06575 Package or function string is in an invalid state
Cause:
A SQL statement references a PL/SQL function that is in an invalid state. Oracle attempted to compile the function, but detected errors.
ORA-06576 not a valid function or procedure name
Description:
ORA-06576 not a valid function or procedure name
Cause:
Could not find a function (if an INTO clause was present) or a procedure (if the statement did not have an INTO clause) to call.
ORA-06577 output parameter not a bind variable
Description:
ORA-06577 output parameter not a bind variable
Cause:
The argument corresponding to an IN/OUT or OUT parameter for a function or a procedure or a function return value in a CALL statement must be a bind variable.
ORA-06578 output parameter cannot be a duplicate bind
Description:
ORA-06578 output parameter cannot be a duplicate bind
Cause:
The bind variable corresponding to an IN/OUT or OUT parameter for a function or a procedure or a function return value in a CALL statement cannot be a duplicate bind variable.
ORA-06580 Hash Join ran out of memory while keeping large rows in memory
Description:
ORA-06580 Hash Join ran out of memory while keeping large rows in memory
Cause:
Hash Join reserves 3 slots (each slot size = DB_BLOCK_SIZE * HASH_MULTIBLOCK_IO_COUNT) for a row. If a row is larger than that, this error will be raised.