OraFAQ Forum: Forms » getting error frm 21011 , ora -65020 , while calling forms from menu

Home » Developer & Programmer » Forms » getting error frm 21011 , ora -65020 , while calling forms from menu

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

getting error frm 21011 , ora -65020 , while calling forms from menu [message #556524]

Tue, 05 June 2012 02:06

ariffcal
Messages: 107
Registered: April 2011

Senior Member

getting error frm 21011 , ora -65020 , while calling forms from menu ,
the forms are also passing parameters between forms 1 and forms 2 .

The following code is in menu item .

declare
uname varchar2(30);
cname varchar2(40);
pl_id paramlist;
userid varchar2(20) := name_in('parameter.user_name');
mcode varchar2(10) := name_in('parameter.mc_name');
--fileid varchar2(10) := '0101201';
m_priv_list varchar2(200);
begin
--fname := its.it_security.get_opt_name(fileid);
-- m_priv_list := its.it_security.get_usr_rolepriv(fileid,userid);
pl_id := get_parameter_list('tempdata');
if not ID_NULL(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id := create_parameter_list('tempdata');
--add_parameter(pl_id,'priv_list',text_parameter,m_priv_list);
add_parameter(pl_id,'muser',text_parameter,userid);

call_form('FirstInventory.fmx',hide,do_replace,no_query_only,pl_id);
exception
when others then
message(sqlerrm);
message(sqlerrm);
end;

Report message to a moderator

Re: getting error frm 21011 , ora -65020 , while calling forms from menu [message #556535 is a reply to message #556524]

Tue, 05 June 2012 03:17

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Remove WHEN OTHERS; it is useless here.

What are these errors (their description)? Are you sure that there is ORA-65020 error? I don't think so, but - prove me wrong.

There *is* ORA-06502, though:
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.

If that is the error you got, check whether values you are storing into variables you created "fit" in there (i.e. make sure they are not larger than variables' size).

Also, before posting your next message, have a look at How to use [code] tags and make your code easier to read?. Clean up your code - don't post commented lines as they are - obviously - not executed, but make unnecessary noise for us. And, above all, post accurate information (your questionable "ORA-65020").

[Updated on: Tue, 05 June 2012 03:17]

Report message to a moderator

Previous Topic:	How to find the line number of error in forms6i
Next Topic:	show empno by order

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 22:05:10 CDT 2024