Home » Developer & Programmer » Forms » Forms works differently when calling Database package from oracle forms 10g (Oracle form 10g & OS: Windows 7)
Forms works differently when calling Database package from oracle forms 10g [message #629279] Fri, 05 December 2014 08:23 Go to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Team,

I am calling a procedure which is in database package from POST-FORM trigger.
Within that procedure I have some update statement.
When executing the screen it throws error "FRM-40735 : POST-FORM trigger raised unhandled exception ORA-04091" after investigating further I can see the message from backtrace as "ORA-04091: table <<tablename>> is mutating, trigger/function may not see it ORA-06512"
The value which I am passing to database procedure is correct.

And the strange thing is when I am creating the same procedure in the form (program units) , the form works properly.

I have no idea why form behaving very different while calling from the same from database packge.

Please help me out.

Thanks



Re: Forms works differently when calling Database package from oracle forms 10g [message #629281 is a reply to message #629279] Fri, 05 December 2014 08:38 Go to previous messageGo to next message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
It would be helpful to see the code for your database package as well as the code in your Post-Form trigger. Also, do you have a trigger on the table itself?

Craig...
Re: Forms works differently when calling Database package from oracle forms 10g [message #629284 is a reply to message #629281] Fri, 05 December 2014 09:16 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hi,
thanks for reply.

Yes, I have trigger on table but there is query on the same table within that trigger.
Ans when I create the exactly same procedure on forms then it works properly.
Re: Forms works differently when calling Database package from oracle forms 10g [message #629285 is a reply to message #629284] Fri, 05 December 2014 09:25 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
What type of trigger?
Re: Forms works differently when calling Database package from oracle forms 10g [message #629323 is a reply to message #629285] Sun, 07 December 2014 08:30 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
After row update
Re: Forms works differently when calling Database package from oracle forms 10g [message #629334 is a reply to message #629323] Sun, 07 December 2014 13:34 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
A select against a table in an after update row trigger on the same table will always give a mutating table error. If you're not always getting the error then I can only assume that the select is sometimes bypassed - it's in an IF for example.

The select has to be removed.
Previous Topic: Calculated Field changes value when Scrolling a record set.
Next Topic: What version of Oracle forms am i running (merged)
Goto Forum:
  


Current Time: Thu Mar 28 17:30:18 CDT 2024