OracleRef

MenuMenu

Home Home
Contact Contact

Loading

ORA-06500 ORA-06500


ORA-06501 ORA-06501


ORA-06502 ORA-06502


ORA-06503 ORA-06503


ORA-06504 ORA-06504


ORA-06505 ORA-06505


ORA-06508 ORA-06508


ORA-06509 ORA-06509


ORA-06510 ORA-06510


ORA-06511 ORA-06511


ORA-06513 ORA-06513


ORA-06514 ORA-06514


ORA-06515 ORA-06515


ORA-06516 ORA-06516


ORA-06517 ORA-06517


ORA-06518 ORA-06518


ORA-06519 ORA-06519


ORA-06520 ORA-06520


ORA-06521 ORA-06521


ORA-06522 ORA-06522




 
ORA-06512

 ORA-06512

Share

Title :

ORA-06512 at string line string





Cause :
Backtrace message as the stack is unwound by unhandled exceptions.

Action :
Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or database administrator.




 
 
2011-04-04 09:22:09: Emilien
Example:
declare
   v_my_number number(2);
begin
   v_my_number := 100;
end;
 
 
You have this error message:
 

ORA-06502

: PL/SQL: numeric or value error: number precision too large

ORA-06512

: at line 4
 
The first line of the error message (ie:

ORA-06502

) indicates the error that occurred, while the second line of the error message (ie:

ORA-06512

) indicates that the error occurred at line 4 of the PLSQL code.
 
In this example, you've tried to assign a 3 digits number to a variable called v_my_number that can only handle 2 digits. You could correct this error by redefining the v_my_number variable as number(3).

Action:
declare
   v_my_number number(3);
begin
   v_my_number := 100;
end;

Pseudo:

Comment:
CAPTCHA Image


Reload Captcha Image
Enter Code Below
 
Pensez votre référencement gratuit.
Copyright © 2009-2014 OracleRef