OraFAQ Forum: Forms » FRM-21011: PL/SQL unhandled exception ORA-306500

Home » Developer & Programmer » Forms » FRM-21011: PL/SQL unhandled exception ORA-306500

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

FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211164]

Tue, 26 December 2006 23:10

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

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211308 is a reply to message #211164]

Wed, 27 December 2006 22:07

myclassic
Messages: 136
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

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211321 is a reply to message #211308]

Wed, 27 December 2006 23:53

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

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211323 is a reply to message #211164]

Thu, 28 December 2006 00:01

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

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #211324 is a reply to message #211323]

Thu, 28 December 2006 00:08

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.....

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #212115 is a reply to message #211324]

Wed, 03 January 2007 18:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444130 is a reply to message #212115]

Thu, 18 February 2010 15:35

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

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444152 is a reply to message #444130]

Thu, 18 February 2010 22:14

myclassic
Messages: 136
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.

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444184 is a reply to message #444152]

Fri, 19 February 2010 02:49

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: FRM-21011: PL/SQL unhandled exception ORA-306500 [message #444189 is a reply to message #444130]

Fri, 19 February 2010 04:06

ramoradba
Messages: 2456
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

Report message to a moderator

Previous Topic:	how to cancel a report from a form
Next Topic:	date field with time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:41:14 CDT 2024