Oracle7 Server Messages

Contents Index Home Previous Next

06500-06599: PL/SQL

ORA-06500 PL/SQL: storage error

Cause:This is a rare internal error message. Memory has been exhausted or corrupted.
Action:Contact customer support.
ORA-06501 PL/SQL: internal error num, arguments [num], [num], [num], [num], [num], [num]

Cause:This is an internal error message. An error has been detected in a PL/SQL program.
Action:Contact customer support.
ORA-06502 PL/SQL: numeric or value error

Cause:An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Action:Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
ORA-06503 PL/SQL: Function returned without value

Cause:A call to a PL/SQL function completed, but no RETURN statement was executed.
Action:Rewrite the PL/SQL function, making sure that it always returns a value of a proper type.
ORA-06504 PL/SQL: Return types of Result Set variables or query do not match

Cause:Number and/or types of columns in a query do not match the declared return type of a Result Set variable, or the declared types of two Result Set variables do not match.
Action:Change the program statement or declaration. Identify the query to which the variable, during execution, actually refers.
ORA-06508 PL/SQL: could not find program unit being called

Cause:An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.
Action:Check that all referenced programs, including their package bodies, exist and are compatible.
ORA-06509 PL/SQL: ICD vector missing for this package

Cause:This indicates a version clash between some package distributed with an Oracle product and the product executable.
Action:Contact customer support.
ORA-06510 PL/SQL: unhandled user-defined exception str

Cause:A user-defined exception was raised by PL/SQL code, but not handled.
Action:Fix the problem causing the exception or write an exception handler for this condition. It may be necessary to contact the application or database administrator.
ORA-06511 PL/SQL: cursor already open

Cause:An attempt was made to open a cursor that was already open.
Action:Close the cursor before attempting to reopen it.
ORA-06512 at str line num

Cause:This is usually the last of a message stack and indicates where a problem occurred in the PL/SQL code.
Action:Fix the problem causing the exception or write an exception handler for this condition. It may be necessary to contact the application or database administrator.
ORA-06513 PL/SQL: index for PL/SQL table out of range for host language array

Cause:An attempt was made to copy a PL/SQL table to a host language array, but an index in the table is either less than one or greater than the maximum size of the host language array. When copying PL/SQL tables to host language arrays, the table entry at index 1 is placed in the first element of the array, the entry at index 2 is placed in the second element of the array, and so on. If a table entry was not assigned, then the corresponding element in the host language array is set to NULL.
Action:Increase the size of the host language arrays or decrease the size of the PL/SQL table. Also make sure that you do not use index values less than 1.
ORA-06514 PL/SQL: The remote call cannot be handled by the server

Cause:The remote call had parameters that were cursor variables. This cannot be handled by stored procedures on your server.
Action:Avoid using cursor variables as parameters for stored procedures on this server or upgrade your server to a version that supports this.

ORA-06540 PL/SQL compilation error

Cause:A PL/SQL compilation error occurred. However, the user generally will not see this error message. Instead, there will be accompanying PLS-nnnnn error messages.
Action:See accompanying PLS-nnnnn error messages.
ORA-06541 PL/SQL: compilation error - compilation aborted

Cause:A PL/SQL compilation error occurred and the compilation was aborted. However, the user generally will not see this error message. Instead, there will be accompanying PLS-nnnnn error messages.
Action:See accompanying PLS-nnnnn error messages.
ORA-06544 PL/SQL: internal error, arguments:arg1, arg2, arg3, arg4, arg5, arg6, arg7, arg8

Cause:A PL/SQL internal error occurred.
Action:Report this as a bug; the first argument is the internal error number.
ORA-06550 line num, column num: str

Cause:A PL/SQL compilation error has occurred. The numbers given for line and column are the location in the PL/SQL block where the error occurred.
Action:Refer to the following PL/SQL messages for more information about the error.
ORA-06554 package DBMS_STANDARD must be created before using PL/SQL

Cause:The data dictionary script required by PL/SQL has not yet been run.
Action:See the Oracle7 Server Administrator's Guide and your Oracle7 operating system-specific documentation for more information.
ORA-06555 this name is currently reserved for use by user SYS

Cause:An attempt was made to create a user-owned package named STANDARD, DBMS_STANDARD, or DBMS_OUTPUT. This is not allowed.
Action:Choose another name for the package.
ORA-06556 the pipe is empty, cannot fulfill the UNPACK_MESSAGE request

Cause:There are no more items in the pipe.
Action:Check that the sender and receiver agree on the number and types of items placed on the pipe.
ORA-06557 null values are not allowed for any parameters to pipe ICD's

Cause:Internal error from the DBMS_PIPE package.
Action:Contact customer support.
ORA-06558 buffer in DBMS_PIPE package is full. No more items allowed

Cause:The pipe buffer size has been exceeded.
ORA-06559 wrong datatype requested, type, actual datatype is type

Cause:The sender put a different datatype on the pipe than that being requested, package DBMS_PIPE. The recognized datatypes and the corresponding numbers are: 6 - number, 9 - char, 12 - date.
Action:Check that the sender and receiver agree on the number and types of items placed on the pipe.
ORA-06562 type of OUT argument must match type of column or bind variable

Cause:An attempt was made to get the value of a column or a bind variable by calling procedure COLUMN_VALUE or VARIABLE_VALUE of package DBMS_SQL. However, the type of the given out argument was different from the type of the column or bind variable that was previously defined by calling procedure DEFINE_COLUMN, for defining a column, or BIND_VARIABLE, for binding a bind variable, of package DBMS_SQL.
Action:Pass in an OUT argument of the correct type when calling procedure COLUMN_VALUE or VARIABLE_VALUE. The right type is the type that was provided when defining the column or binding the bind variable.
ORA-06560 pos, num, is negative or larger than the buffer size, num

Cause:Internal error from the DBMS_PIPE package.
Action:Contact customer support.
ORA-06563 top level procedure or function specified, cannot have subparts

Cause:The name to be resolved was specified with three parts, a.b.c, but the a.b part resolves to a top level procedure or function that does not have nested procedures. This can also happen with a two-part name, a.b, where a is a synonym for a top level package or procedure.
Action:Specify a procedure or function within a package or a top level procedure or function.
ORA-06564 object name does not exist

Cause:The named object could not be found. Either it does not exist or you do not have permission to access it.
Action:Create the object or get permission to access it.
ORA-06565 cannot execute name from within stored procedure

Cause:The named procedure cannot be executed from within a stored procedure, function, or package. This function can only be used from PL/SQL anonymous blocks.
Action:Remove the procedure from the calling stored procedure.
ORA-06566 invalid number of rows specified

Cause:An invalid number of rows was specified in a call to the procedures DEFINE_COLUMN in the package DBMS_SQL. For a given parsed statement in a given cursor, all columns must be defined to have the same number of rows, so all the calls to DEFINE_COLUMN must specify the same number of rows.
Action:Specify a number that matches the number for previously defined columns.
ORA-06567 invalid number of values specified

Cause:An invalid number of values to be bound was specified in a call to the procedure BIND_VARIABLE in the package DBMS_SQL. For a given parsed statement in a given cursor, the same number of values must be bound for all bind variables, so all the calls to BIND_VARIABLE must specify the same number of values.
Action:Make sure that the same number of values are given for each of the bind variables.
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 Oracle.
Action:Ensure that all PL/SQL packages are upgraded to the latest release of Oracle by following the upgrade instructions noted in the README document or by running the CATPROC.SQL script.
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.
Action:Make sure that a correct shared cursor name is given. Names are a string of the form 'HHHHHHHH,SDDDDDDDDDD' where the H's are an 8-digit hex number from the 'address' column of V$SQLAREA, and the D's are a 1- to 10-digit decimal number with an optional leading sign from the 'hash_value' column.
ORA-06571 function name does not guarantee not to update database

Cause:There are two possible causes for this message:

Action:If the referenced function is a packaged PL/SQL function: Recreate 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.
ORA-06572 function name has out arguments

Cause:A SQL statement references either a packaged or a stand-alone PL/SQL function that contains an OUT parameter in its argument list. PL/SQL functions referenced by SQL statements must not contain the OUT parameter.
Action:Recreate the PL/SQL function without the OUT parameter in the argument list.
ORA-06573 function name modifies package state, cannot be used here

Cause:There are two possible causes for this message:

Action:If the function is a packaged PL/SQL function: recreate the function and include a pragma containing the 'Write no Package State' (WNPS).
ORA-06574 function name references package state, cannot execute remotely

Cause:There are two possible causes for this message:

Action:If the function is a packaged function: Recreate the function and include a pragma containing the 'Write no Package State' (WNPS) and 'Read no Package State' (RNPS) arguments.
ORA-06575 function name 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.
Action:Check the SQL statement and the PL/SQL function for syntax errors or incorrectly assigned, or missing, privileges for a referenced object.
ORA-06580 Hash Join ran out of memory while keeping large rows in memory

Cause:Hash Join reserved 3 slots (each slot size = DB_BLOCK_SIZE * HASH_JOIN_MULTIBLOCK_IO_COUNT) for a row. If a row is larger than that, this error will be raised.
Action:Increase HASH_JOIN_MULTIBLOCK_IO_COUNT so that each joined row fits in a slot. HASH_AREA_SIZE may also need to be increased.


Contents Index Home Previous Next