Home » Developer & Programmer » Forms » FRM-21011:pl/sql unhandled exception ORA-06502 (Oracle 9i on linux(red-hat),form6i on window-xp)
FRM-21011:pl/sql unhandled exception ORA-06502 [message #325114] Thu, 05 June 2008 01:12 Go to next message
anilsharma
Messages: 10
Registered: June 2008
Location: INDIA
Junior Member

I m attach library in menu item_enable_disable purpose
disable the block item when i view the record my code as
under view all menu item

DECLARE
blk_name varchar(60);
form_name varchar(60);
BEGIN
execute_query;
form_name := get_application_property(current_form_name);
blk_name := get_form_property(form_name,first_block);
item_enable_disable(blk_name,property_false);
end;



AND item_enable_disable(blk_name,property_false) code is


PROCEDURE ITEM_ENABLE_DISABLE(blk_name IN char,item_on_off in number) IS
nxt_itemname varchar2(70);
itemtype varchar2(25);
itemcanvas varchar2(25);
BEGIN
nxt_itemname := blk_name ||'.'||get_block_property(blk_name,first_item);
loop
itemtype := get_item_property(nxt_itemname,item_type);
itemcanvas := get_item_property(nxt_itemname,item_canvas);
if(itemtype <> 'DISPLAY ITEM')and (itemcanvas is not null)
and (get_item_property(nxt_itemname,enabled)='TRUE') then
set_item_property(nxt_itemname,updateable,item_on_off);
end if;
nxt_itemname := blk_name ||'.'||get_item_property(nxt_itemname,next_navigation_item);
if(nxt_itemname=blk_name||'.ROWID') then
exit;
end if;
end loop;
END;
any body tell me why i m facing the problume
thanks
anil sharma
Re: FRM-21011:pl/sql unhandled exception ORA-06502 [message #325124 is a reply to message #325114] Thu, 05 June 2008 01:41 Go to previous messageGo to next 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.
Re: FRM-21011:pl/sql unhandled exception ORA-06502 [message #325126 is a reply to message #325114] Thu, 05 June 2008 01:45 Go to previous messageGo to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
there may some problem of type mismatch or variable length may be short
Re: FRM-21011:pl/sql unhandled exception ORA-06502 [message #325128 is a reply to message #325124] Thu, 05 June 2008 01:52 Go to previous messageGo to next message
anilsharma
Messages: 10
Registered: June 2008
Location: INDIA
Junior Member

ORA-06502 PL/SQL: numeric or value error string
I know it.but in this case what need to do that when i veiwall record of form then not allow to change any field of this form
thanks
anil sharma

Re: FRM-21011:pl/sql unhandled exception ORA-06502 [message #325130 is a reply to message #325128] Thu, 05 June 2008 01:57 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
anilsharma
what need to do

Oracle
Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
Re: FRM-21011:pl/sql unhandled exception ORA-06502 [message #325465 is a reply to message #325130] Fri, 06 June 2008 04:48 Go to previous messageGo to next message
anilsharma
Messages: 10
Registered: June 2008
Location: INDIA
Junior Member

my problem is not solve yet
i m increase the variable length also
thanks
Re: FRM-21011:pl/sql unhandled exception ORA-06502 [message #325478 is a reply to message #325465] Fri, 06 June 2008 05:39 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I have created a sample form based on Scott's "dept" table, used your code and - no error at all. Though, I use Forms 10g (as opposed to your 6i).

What you might do is to put message-pause pairs into the procedure code so that you could follow its execution; display current item name, its type (with additional information you might be interested in) and loop until error appears. Then check what's going on and, hopefully, fix the bug.

Also, it would be nice if you learn how to indent code and use [code] tags to preserve formatting while posting your code on the Forum; it would make reading much easier. Check OraFAQ Forum Guide to learn how to do that.
Previous Topic: How to Update a column from the other column?
Next Topic: populate lov at run time
Goto Forum:
  


Current Time: Wed Dec 07 20:13:23 CST 2016

Total time taken to generate the page: 0.11272 seconds