| FRM-21011 & ora 6502 [message #328383] |
Fri, 20 June 2008 00:33  |
subhadeep82
Messages: 1
Registered: June 2008
Location: india
|
Junior Member |
|
|
i m getting the following error while running a menu in an application,
FRM 21011 pl/sql unhandled exception ORA-6502
please reply
BEGIN
message('1');
SELECT NVL(USERGROUP,'TESTI') INTO V_USERGROUP FROM AFUSERS WHERE USERNAME=L_UserName;
message('2');
its not reaching messege 2
|
|
|
|
| Re: FRM-21011 & ora 6502 [message #328400 is a reply to message #328383] |
Fri, 20 June 2008 01:26  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
| Oracle | ORA-06502 PL/SQL: numeric or value error string
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.
|
How did you declare V_USERGROUP? I guess that, if it wasDECLARE
V_USERGROUP afusers.usergroup%type;
Perhaps you should learn how to post all relevant information when asking a question; insufficient info causes confusion.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
