ORA-06512 is one of the common error seen in PLSQL programs.
Here is what documentation says about this error
Reference :Oracle documentation
Explanation of the error:
Error Ora-06512 means the backtrace message as the stack is being unwound by unhandled exceptions in your PLSQL code. This is a catch-all error for PLSQL exceptions and is commonly seen.
Ora-06512 does not indicate the actual error, but the line number of the unhandled error in the PLSQL code. Ora-06512 will typically appear in a message stack in which the preceding message names the reason for the error, such as in the following example:
|
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 1112 |
The options to resolve this Oracle error are:
1) Fix the condition that is causing the unhandled error.
2) Write an exception handler for this unhandled error.
3) Contact your DBA for help.
Lets see few example on how to work on it
| CREATE OR REPLACE PROCEDURE Testora_proc
AS Site_name varchar2(5); begin site_name := ‘techgoeasy.com’; end; / Procedure created. sql> Exec Testora_proc ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 5 |
In the example given above, procedure get compiled successfully but it gave errors while execution
So actual error is the error
| ORA-06502: PL/SQL: numeric or value error: character string buffer too small |
We can easily correct it by increasing the size of the variable
| CREATE OR REPLACE PROCEDURE Testora_proc
AS Site_name varchar2(20); begin site_name := ‘techgoeasy.com’; end; / Procedure created.
Exec Testoraproc
PL/SQL procedure successfully completed. |
We can solve this using exception handler also
| CREATE OR REPLACE PROCEDURE Testora_proc
AS Site_name varchar2(5); begin site_name := ‘techgoeasy.com’; EXCEPTION WHEN OTHERS THEN site_name := ‘tech’;
end; / Procedure created.
Exec Testoraproc
PL/SQL procedure successfully completed. |
So we can resolve the problem by carefully checking the full error stack and taking required action item
Hope you like this post on ORA-6512
Related articles
ORA-00911: invalid character Common Issues and Resolution
ORA-03113: end-of-file on communication channel
How to resolve the ORA-00257 error in Oracle database
ORA-27154: post/wait create failed during startup
How to resolve ORA-29913 with external tables
ora-20001 in Gather schema stats on 11g(FND_HISTOGRAM_COLS)
Concurrent Manager:cleanup_node failed due to ORA-01427