| FRM-21011:pl/sql unhandled exception ORA-06502 [message #325114] |
Thu, 05 June 2008 01:12  |
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  |
 |
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: FRM-21011:pl/sql unhandled exception ORA-06502 [message #325478 is a reply to message #325465] |
Fri, 06 June 2008 05:39 |
|
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
