OraFAQ Forum: Forms » Any help, its urgent

Home » Developer & Programmer » Forms » Any help, its urgent

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

Any help, its urgent [message #81291]

Thu, 30 January 2003 16:00

Vinod
Messages: 76
Registered: April 1999

Member

I am calling a database function from the forms. sometimes i get the an error message
"100501: non-ORACLE exception". How to trap this error message in the forms and show a informative user defined error message.

Any help appreciated

Thanks

Report message to a moderator

Re: Any help, its urgent [message #81297 is a reply to message #81291]

Fri, 31 January 2003 06:04

magnetic
Messages: 324
Registered: January 2003

Senior Member

try to get a value from the database when this exception occures
example

database function :

function f1 (var1 in number
,var2 out number)

exception
when others then
var2:=9999
return(var2);

in forms:

v_variable:=f1(var1,var2);
if var2=9999 then
show_message('non-ORACLE exception');
end if;

Report message to a moderator

Previous Topic:	free download oracle forms 3.0
Next Topic:	forms to excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 21:21:10 CDT 2024