Home » Developer & Programmer » Forms » FRM-21011 & ora 6502
FRM-21011 & ora 6502 [message #328383] Fri, 20 June 2008 00:33 Go to next message
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 Go to previous message
Littlefoot
Messages: 20900
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 was
DECLARE
  V_USERGROUP afusers.usergroup%type;
it might work just fine (except if it was a character column shorter than 5 characters (i.e. LENGTH('TESTI')).

Perhaps you should learn how to post all relevant information when asking a question; insufficient info causes confusion.
Previous Topic: how to invoke the LOV?
Next Topic: update statement
Goto Forum:
  


Current Time: Wed Dec 07 18:17:09 CST 2016

Total time taken to generate the page: 0.08546 seconds