OraFAQ Forum: Forms » 100501- non-ORACLE Exception

Home » Developer & Programmer » Forms » 100501- non-ORACLE Exception (Oracle forms 6i)

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

100501- non-ORACLE Exception [message #609116]

Sun, 02 March 2014 23:41

shan_
Messages: 3
Registered: February 2014
Location: Singapore

Junior Member

Hi,

I am using forms 6i for development and back end oracle10g.

I am getting "100501- non-ORACLE Exception" at "when_button_pressed" after showing a alert.

I know this is due to raise form_trigger_failure.

how to handle this?

please explain .......

[Updated on: Mon, 03 March 2014 00:09]

Report message to a moderator

Re: 100501- non-ORACLE Exception [message #609117 is a reply to message #609116]

Mon, 03 March 2014 00:07

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

Senior Member
Account Moderator

It is kind of difficult to guess what might be wrong as you didn't post code that raised that error. However: do you, by any chance, have an exception handler section in your code which contains RAISE FORM_TRIGGER_FAILURE? Something like

begin 
  do some stuff here
exception                            --> this section
  when others then                   --> don't use WHEN OTHERS
    raise form_trigger_failure;
end;

If so, remove it and run the form again. What happens?

Otherwise, please, post your code.

Report message to a moderator

Re: 100501- non-ORACLE Exception [message #609118 is a reply to message #609117]

Mon, 03 March 2014 00:11

shan_
Messages: 3
Registered: February 2014
Location: Singapore

Junior Member

Hi,

thanks for your reply.

I also did the same.it works.

Report message to a moderator

Previous Topic:	problem of refreshing record in a form 10g
Next Topic:	"sys_refcursor" when expecting one of the following (

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 28 05:30:54 CDT 2025