Emergency [message #38042] |
Thu, 14 March 2002 13:37 |
Tom
Messages: 67 Registered: June 1998
|
Member |
|
|
Guys
Err: -6502 STR: ORA-06502: PL/SQL: numeric or value error ORA-06512:
any suggestions
thanks in advance
|
|
|
Re: Emergency [message #38046 is a reply to message #38042] |
Thu, 14 March 2002 23:48 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
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-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.
|
|
|