{"id":1781,"date":"2016-03-12T12:11:09","date_gmt":"2016-03-12T09:11:09","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1781"},"modified":"2016-10-21T12:13:03","modified_gmt":"2016-10-21T09:13:03","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-06500-to-ora-06600","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-06500-to-ora-06600\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-06500 to ORA-06600"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-06500 to ORA-06600<\/strong><\/p>\n

\n
ORA-06500: PL\/SQL: storage error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PL\/SQL was unable to allocate additional storage. This message normally appears with an ORA-4030 or ORA-4031 error which gives additional information. Sometimes this error can be caused by runaway programs.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a01) Ensure there are no issues or bugs in your PL\/SQL program which are causing excessive amounts of memory to be used. 2) Programmatically cause unused objects to be freed (e.g. by setting them to NULL). 3) Increase the amount of shared or process memory (as appropriate) available to you.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06501: PL\/SQL: program error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This is an internal error message. An error has been detected in a PL\/SQL program.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06502: PL\/SQL: numeric or value errorstring<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06503: PL\/SQL: Function returned without value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call to PL\/SQL function completed, but no RETURN statement was executed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rewrite PL\/SQL function, making sure that it always returns a value of a proper type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06504: PL\/SQL: Return types of Result Set variables or query do not match<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Number and\/or types of columns in a query does not match declared return type of a result set variable, or declared types of two Result Set variables do not match.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the program statement or declaration. Verify what query the variable actually refers to during execution.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06505: PL\/SQL: variable requires more than 32767 bytes of contiguous memory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A PL\/SQL variable was declared with a constraint which required more than 32767 bytes of memory. PL\/SQL does not currently support allocations of contiguous memory greater than 32767 bytes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Consider reducing the constraint in the variable declaration. If that is not possible, try changing the database or national character set to such, that requires less memory for the same constraint. Note: changing the character set will impact execution of all PL\/SQL code.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06510: PL\/SQL: unhandled user-defined exception<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A user-defined exception was raised by PL\/SQL code, but not handled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06511: PL\/SQL: cursor already open<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to open a cursor that was already open.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Close cursor first before reopening.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06512: at\u00a0string<\/i>line\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Backtrace message as the stack is unwound by unhandled exceptions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06513: PL\/SQL: index for PL\/SQL table out of range for host language array<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt is being 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, etc. If an table entry has not been assigned then the corresponding element in the host language array is set to null.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Increase size of host language array, or decrease size of PL\/SQL table. Also make sure that you don’t use index values less than 1.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06514: PL\/SQL: The remote call cannot be handled by the server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The remote call has parameters that are cursor variables or lob variables. This cannot be handled by stored procedures on your server.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Avoid using cursor variables or lob variables as parameters for stored procedures on this server or upgrade your server to a version that supports this.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-06515: PL\/SQL: unhandled exception\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An exception was raised by PL\/SQL code, but not handled. The exception number is outside the legal range of Oracle errors.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06516: PL\/SQL: the Probe packages do not exist or are invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A Probe operation, probably an attempt to initialize the ORACLE server to debug PL\/SQL, could not be completed because the Probe packages were not loaded or have become invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0DBA should load the Probe packages. This can be done by running the pbload.sql script supplied with the RDBMS.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06517: PL\/SQL: Probe error –\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred while passing a Probe operation to the server for execution.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Refer to the entry for the embedded error message.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06518: PL\/SQL: Probe version\u00a0string<\/i>\u00a0incompatible with version\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The current version of Probe is incompatible with the version on the ORACLE server.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Refer to the documentation to ensure that this degree of compatibility is supported.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06519: active autonomous transaction detected and rolled back<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Before returning from an autonomous PL\/SQL block, all autonomous transactions started within the block must be completed (either committed or rolled back). If not, the active autonomous transaction is implicitly rolled back and this error is raised.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that before returning from an autonomous PL\/SQL block, any active autonomous transactions are explicitly committed or rolled back. ———————————————————————– 06520 through 06529 reserved for Foreign function errors<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06520: PL\/SQL: Error loading external library<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error was detected by PL\/SQL trying to load the external library dynamically.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the stacked error (if any) for more details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06521: PL\/SQL: Error mapping function<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error was detected by PL\/SQL trying to map the mentioned function dynamically.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the stacked error (if any) for more details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06522:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORA-06520 or ORA-065211 could stack this error with a system specific error string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error string should give the cause for errors ORA-06520 or ORA-065211<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06523: Maximum number of arguments exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There is an upper limit on the number of arguments that one can pass to the external function.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the port specific documentation on how to calculate the upper limit.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06524: Unsupported option :\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The option specified is an unsupported feature for external procedures.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the syntax in the external specification<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06525: Length Mismatch for CHAR or RAW data<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The length specified in the length variable has an illegal value. This can happen if you have requested requested a PL\/SQL INOUT, OUT or RETURN raw variable to be passed as a RAW with no corresponding length variable. This error can also happen if there is a mismatch in the length value set in the length variable and the length in the orlvstr or orlraw.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the external procedure code and set the length variable correctly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06526: Unable to load PL\/SQL library<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PL\/SQL was unable to instantiate the library referenced by this referenced in the EXTERNAL syntax. This is a serious error and should normally not happen.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report this problem to customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06527: External procedure SQLLIB error:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred in sqllib during execution of a Pro* external procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The message text indicates the actual SQLLIB error that occurred. Consult the Oracle Error Messages and Codes manual for a complete description of the error message and follow the appropriate action.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06528: Error executing PL\/SQL profiler<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred in during execution of a PL\/SQL profiler procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the stacked errors for more details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06529: Version mismatch – PL\/SQL profiler<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The PL\/SQL profiler package (dbmspb.sql, prvtpbp.plb) does not match the version of the code in the server implementing the profiler.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Run the package profload.sql in $ORACLE_HOME\/rdbms\/admin to load the correct version of the PL\/SQL profiler packages<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06530: Reference to uninitialized composite<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An object, LOB, or other composite was referenced as a left hand side without having been initialized.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Initialize the composite with an appropriate constructor or whole-object assignment.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06531: Reference to uninitialized collection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An element or member function of a nested table or varray was referenced (where an initialized collection is needed) without the collection having been initialized.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Initialize the collection with an appropriate constructor or whole-object assignment.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06532: Subscript outside of limit<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A subscript was greater than the limit of a varray or non-positive for a varray or nested table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the program logic and increase the varray limit if necessary.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06533: Subscript beyond count<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An in-limit subscript was greater than the count of a varray or too large for a nested table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the program logic and explicitly extend if necessary.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06534: Cannot access Serially Reusable package\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The program attempted to access a Serially Reusable package in PL\/SQL called from SQL context (trigger or otherwise). Such an access is currently unsupported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the program logic and remove any references to Serially Reusable packages (procedure, function or variable references) which might happen in PL\/SQL called from sql context (trigger or otherwise).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06535: statement string in\u00a0string<\/i>\u00a0is NULL or 0 length<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The program attempted to use a dynamic statement string that was either NULL or 0 length.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the program logic and ensure that the dynamic statement string is properly initialized.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06536: IN bind variable bound to an OUT position<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The program attempted to bind an IN bind variable to a statement that was expecting an OUT bind variable at that position.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that an OUT or IN OUT bind mode is specified for the bind argument.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06537: OUT bind variable bound to an IN position<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The program attempted to bind an OUT bind variable to a statement that was expecting an IN bind variable at that position.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that an IN or IN OUT bind mode is specified for the bind argument.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06538: statement violates\u00a0string<\/i>\u00a0RESTRICT_REFERENCES pragma<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The program attempted to execute a dynamic statement which does not meet the purity level specified (in the pragma RESTRICT_REFERENCES directive) for the module executing the statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the dynamic statement meets the purity level specified for the module executing the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06539: target of OPEN must be a query<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The program attempted to perform an OPEN cursor operation on a dynamic statement that was not a query.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the OPEN cursor operation is done on a dynamic query statement. ——————————————————– 06540 through 06549 reserved for pl\/sql error handling<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06540: PL\/SQL: compilation error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A pl\/sql compilation error occurred. However, the user generally will not see this error message. Instead, there will be accompanying PLS-nnnnn error messages.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See accompanying PLS-nnnnn error messages.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06541: PL\/SQL: compilation error – compilation aborted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A pl\/sql compilation error occurred and the compilation was aborted; but the compilation unit was written out to the backing store. However, unlike ora-06545, the user generally will not see this error message. Instead, there will be accompanying PLS-nnnnn error messages.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See accompanying PLS-nnnnn error messages.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06544: PL\/SQL: internal error, arguments: [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A pl\/sql internal error occurred.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report as a bug; the first argument is the internal error nuber.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06545: PL\/SQL: compilation error – compilation aborted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A pl\/sql compilation error occurred and the compilation was aborted completely without the compilation unit being written out to the backing store. Unlike ora-06541, the user will always see this error along with the accompaning PLS-nnnnn error messages.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See accompanying PLS-nnnnn error messages.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06546: DDL statement is executed in an illegal context<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DDL statement is executed dynamically in illegal PL\/SQL context.<\/span><\/span><\/span><\/dd>\n
– Dynamic OPEN cursor for a DDL in PL\/SQL<\/span><\/span><\/span><\/dd>\n
– Bind variable’s used in USING clause to EXECUTE IMMEDIATE a DDL<\/span><\/span><\/span><\/dd>\n
– Define variable’s used in INTO clause to EXECUTE IMMEDIATE a DDL<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use EXECUTE IMMEDIATE without USING and INTO clauses to execute the DDL statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06547: RETURNING clause must be used with INSERT, UPDATE, or DELETE statements<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0EXECUTE IMMEDIATE with a RETURNING clause is used to execute dynamic UPDATE, INSERT, or DELETE statements only.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0use RETURNING clause in EXECUTE IMMEDIATE for INSERT, UPDATE, or DELETE statements only. For other statements, use USING clause instead.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06548: no more rows needed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The caller of a pipelined function did not need more rows to be produced by the pipelined function.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not catch the NO_DATA_NEEDED exception in an exception handling block.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06549: PL\/SQL: failed to dynamically open shared object (DLL):\u00a0string<\/i>:string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One possible cause might be there are too many DLLs open at the same time.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0——————————————————–<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06550: line\u00a0string<\/i>, column\u00a0string<\/i>:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Usually a PL\/SQL compilation error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06554: package DBMS_STANDARD must be created before using PL\/SQL<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The DBMS specific extensions to PL\/SQL’s package “STANDARD” are in package “DBMS_STANDARD”. This package must be created before using PL\/SQL.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create package “DBMS_STANDARD”. The source for this PL\/SQL stored package is provided with the distribution.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06555: this name is currently reserved for use by user SYS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to create a package named “STANDARD”, “DBMS_STANDARD” or “DEBUG_IO”. These are currently reserved for use by user SYS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose another name for your package.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06556: the pipe is empty, cannot fulfill the unpack_message request<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are no more items in the pipe.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the sender and receiver agree on the number and types of items placed on the pipe.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06557: null values are not allowed for any parameters to pipe icd’s<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error from the dbms_pipe package.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06558: buffer in dbms_pipe package is full. No more items allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe buffer size has been exceeded.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06559: wrong datatype requested,\u00a0string<\/i>, actual datatype is\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The sender put different datatype on the pipe than that being requested (package ‘dbms_pipe’). The numbers are: 6 – number, 9 – char, 12 – date.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the sender and receiver agree on the number and types of items placed on the pipe.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06560: pos,\u00a0string<\/i>, is negative or larger than the buffer size,\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error from the dbms_pipe package.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06561: given statement is not supported by package DBMS_SQL<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempting to parse an unsupported statement using procedure PARSE provided by package DBMS_SQL.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only statements which begin with SELECT, DELETE, INSERT, UPDATE, LOCK, BEGIN, DECLARE or << (PL\/SQL label delimiter) are supported.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06562: type of out argument must match type of column or bind variable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempting to get the value of a column or a bind variable by calling procedure COLUMN_VALUE or VARIABLE_VALUE of package DBMS_SQL but the type of the given out argument where to place the value is 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Pass 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06563: name has too many parts<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The name to be resolved was specified as one of the following:<\/span><\/span><\/span><\/dd>\n
– With three parts (A.B.C) but the A.B parts resolved to an object that did not expose visible nested procedures; the C part could not be resolved.<\/span><\/span><\/span><\/dd>\n
– With two parts (A.B) and the A part resolved to an object that did not expose visible nested procedures; the B part could not be resolved.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the valid name of an object or of a packaged procedure or function without specifying any additional trailing parts.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06564: object\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The named object could not be found. Either it does not exist or you do not have permission to access it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the object or get permission to access it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06565: cannot execute\u00a0string<\/i>\u00a0from within stored procedure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The named procedure cannot be executed from within a stored procedure, function or package. This function can only be used from pl\/sql anonymous blocks.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the procedure from the calling stored procedure.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06566: invalid number of rows specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid number of rows was specified in a call to the procedure 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a number that matches that for previously defined columns.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06567: invalid number of values specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid number of values to be bound was specified in a call to the procedure BIND_VARIABLE in the package DBMS_SQL. In order to execute a given parsed statement in a given cursor, the same number of values must have been bound for all bind variables, so when EXECUTE is called, the latest calls to BIND_VARIABLE must must have specified the same number of values to be bound for all bind variables.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the same number of values have been bound for all of the bind variables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06568: obsolete ICD procedure called<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An obsolete ICD procedure was called by a PL\/SQL program. The PL\/SQL program was probably written for an eralier release of RDBMS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that all PL\/SQL programs have been upgraded to the latest release of the RDBMS. This can be accomplished by following upgrade instructions in the README file, or by running the catproc.sql script supplied with the RDBMS.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06569: Collection bound by bind_array contains no elements<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A 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 then at execute time there will be no value for this bind and the statement is meaningless.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fill the collection with the elements you want to bind and try the bind call again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06570: shared pool object does not exist, cannot be pinned\/purged<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified shared pool shared cursor could not be found, therefore it cannot be pinned\/purged.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the procedure from the calling stored procedure.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06571: Function\u00a0string<\/i>\u00a0does not guarantee not to update database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are two possible causes for this message:<\/span><\/span><\/span><\/dd>\n
* A SQL statement references a packaged, PL\/SQL function that does not contain a pragma that prevents the database from being updated.<\/span><\/span><\/span><\/dd>\n
* A SQL statement references a stand-alone, PL\/SQL function that contains an instruction to update the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If 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. If the referenced function is a stand-alone, PL\/SQL function: Do not use the function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06572: Function\u00a0string<\/i>\u00a0has out arguments<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the PL\/SQL function without the OUT parameter in the argument list.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06573: Function\u00a0string<\/i>\u00a0modifies package state, cannot be used here<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are two possible causes for this message:<\/span><\/span><\/span><\/dd>\n
* A SQL statement references a packaged, PL\/SQL function that does not contain a pragma containing the ‘Write no Package State’ (WNPS).<\/span><\/span><\/span><\/dd>\n
* A SQL statement references a stand-alone, PL\/SQL function that modifies a package state. A stand-alone, PL\/SQL function referenced by a SQL statement cannot modify a package state.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the function is a packaged, PL\/SQL function: Recreate the function and include a pragma containing the ‘Write no Package State’ (WNPS). If the function is a stand-alone, PL\/SQL function: Delete the function from the SQL statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06574: Function\u00a0string<\/i>\u00a0references package state, cannot execute remotely<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are two possible causes for this message:<\/span><\/span><\/span><\/dd>\n
* A remote, packaged function or a remote-mapped, local, packaged function that does not contain a pragma with the ‘Write no Package State’ (WNPS) and ‘Read no Package State’ (RNPS) arguments references a package state.<\/span><\/span><\/span><\/dd>\n
* A remote, stand-alone function or a remote-mapped, local, stand-alone function contains a reference to a package state (reads or writes a package variable). Only local functions that are referenced in a SELECT list, VALUES clause of an INSERT statement, or SET clause of an UPDATE statement can modify a package state.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If 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. If the function is a stand-alone function: Do not call the function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06575: Package or function\u00a0string<\/i>\u00a0is in an invalid state<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A SQL statement references a PL\/SQL function that is in an invalid state. Oracle attempted to compile the function, but detected errors.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the SQL statement and the PL\/SQL function for syntax errors or incorrectly assigned, or missing, privileges for a referenced object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06576: not a valid function or procedure name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Could not find a function (if an INTO clause was present) or a procedure (if the statement did not have an INTO clause) to call.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the statement to invoke a function or procedure<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06577: output parameter not a bind variable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the argument to a bind variable<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06578: output parameter cannot be a duplicate bind<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the bind variable to be unique<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06579: Bind variable not big enough to hold the output value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The bind variable specified by the user is not large enough to hold the output returned by the function or a procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a bind variable of larger size.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06580: Hash Join ran out of memory while keeping large rows in memory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Hash Join reserves 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Increase HASH_JOIN_MULTIBLOCK_IO_COUNT so that each joined row fits in a slot. HASH_AREA_SIZE may also need to be increaed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06592: CASE not found while executing CASE statement<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A CASE statement must either list all possible cases or have an else clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Add all missing cases or an else clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06593:\u00a0string<\/i>\u00a0is not supported with natively compiled PL\/SQL modules<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Specified feature is not yet supported for natively compiled PL\/SQL modules yet.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recompile the relevant PL\/SQL modules in non-native mode by setting the parameter plsql_compiler_flags to INTERPRETED.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06595: REF CURSOR parameters are not supported in forwarded RPC calls<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to make a forwarded RPC call with a REF CURSOR parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either call the remote function directly (i.e., not by way of forwarding), or move the remote function to a database where it can be called directly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06596: object cannot be purged, object is permanently kept in shared pool<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified object was permanently kept, therefore, cannot be purged.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use DBMS_SHARED_POOL.UNKEEP procedure to unkeep the object and then purge it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06597: Failed to increase the session’s call stack memory to\u00a0string<\/i>\u00a0bytes at a depth of\u00a0string<\/i>\u00a0calls. (The current maximum is\u00a0string<\/i>\u00a0bytes.)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PL\/SQL program execution used more call stack memory than permitted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0* Ask your DBA to increase the maximum allowed call stack memory.<\/span><\/span><\/span><\/dd>\n
* Decrease the amount of call stack used by the program. This may be accomplished by using fewer, smaller local variables, or by limiting the depth of function call nesting.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06600: LU6.2 Driver: SNA software is not loaded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The SNA software is not running.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Start the SNA software and try again.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-06500 to ORA-06600 ORA-06500: PL\/SQL: storage error Cause:\u00a0PL\/SQL was unable to allocate additional storage. This message normally appears with an ORA-4030 or ORA-4031 error which gives additional information. Sometimes this error can be caused by runaway programs. Action:\u00a01) Ensure there are no issues or bugs in your…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1781","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-sJ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1781"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1781\/revisions"}],"predecessor-version":[{"id":1782,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1781\/revisions\/1782"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1781"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}