Home » Developer & Programmer » Forms » FRM-21011: PL/SQL unhandled exception ORA-306500
FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211164] Tue, 26 December 2006 23:10 Go to next message
prameshgupta
Messages: 5
Registered: September 2006
Location: Mumbai
Junior Member
I am getting the follwoing error at the time of opening the application menu
FRM-21011: PL/SQL unhandled exception ORA-306500
please give me the solution, this is urgent.
thanks in advance
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211308 is a reply to message #211164] Wed, 27 December 2006 22:07 Go to previous messageGo to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
add-------- Exception when others then
message(sqlerrm);
it will show u what the problem is.... wish u good luck
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211321 is a reply to message #211308] Wed, 27 December 2006 23:53 Go to previous messageGo to next message
prameshgupta
Messages: 5
Registered: September 2006
Location: Mumbai
Junior Member
where i have to put this code in the menu

i am getting this error for total application
at the clicking the form in each menu, i am getting this error,

please give me the solution for this problem
this is very urgent

thanks in advance
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211323 is a reply to message #211164] Thu, 28 December 2006 00:01 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

you said: I am getting the follwoing error at the time of opening the application menu

That probably on the main form, I suppose your main form contains your menu
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211324 is a reply to message #211323] Thu, 28 December 2006 00:08 Go to previous messageGo to next message
prameshgupta
Messages: 5
Registered: September 2006
Location: Mumbai
Junior Member
i am connecting on production server everything is working fine
but i am connecting to test server at the time opening the menu
after clicking the form it;s giving this error.
i changed tnsnames.ora, sqlnet.ora
what is the problem
how can i trace it.....
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #212115 is a reply to message #211324] Wed, 03 January 2007 18:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444130 is a reply to message #212115] Thu, 18 February 2010 15:35 Go to previous messageGo to next message
Deepthi102
Messages: 2
Registered: February 2009
Location: Michigan
Junior Member
I have the same problem with Menus. It works perfect in production, doesn't work in test environment.

Any Help will be really appreciated.

Thanks,
Deepthi
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444152 is a reply to message #444130] Thu, 18 February 2010 22:14 Go to previous messageGo to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
FRM-21011: PL/SQL unhandled exception ORA-306500

let us first know what the exception is being generated.
so add in your *code

exception when others then
message(sqlerrm);



*code means a place where this message is being generated. if you are loading the form and this message is being generated then add up this exception line in new form instance trigger.
else in menu code.
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444184 is a reply to message #444152] Fri, 19 February 2010 02:49 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In my opinion such a WHEN OTHERS exception handler is completely useless. Let Oracle raise an exception; your message can only be worse, not better than that.
Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444189 is a reply to message #444130] Fri, 19 February 2010 04:06 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
It would be better if you post your message as a new topic....

Because..
we dont know you version(forms) here.
Even that kind of error may occure for different scenarios.
So better post as a new topic in future.
Basically this error may Occur,if you are doing any
1) EXEC_SQL specially this ORA-306500
2) Connection problems too..
Any remote link objects?
Whats the difference in these..
Quote:
It works perfect in production, doesn't work in test environment

Here on these links you can find a workaround for this error.
So lease try this and get back here with the results.

1) Transalated one.
2) Forum.Oracle
3) One more translated for you.

@myclasic when others then is the worst case i can say.
Goodluck

sriram Smile
Previous Topic: how to cancel a report from a form
Next Topic: date field with time
Goto Forum:
  


Current Time: Thu Sep 29 15:59:31 CDT 2016

Total time taken to generate the page: 0.14709 seconds