Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL mutating error (IFS)
PL/SQL mutating error (IFS) [message #564561] Sat, 25 August 2012 14:31 Go to next message
SteveShephard
Messages: 32
Registered: August 2012
Member
Hi guys,

I am currently working on a piece of PL/SQL within the software programme IFS (not sure if anybody has heard of it?)

Basically the problem seems to be with the loop statement, more specefically a View I created (PCUK_GROUP_ALLOC_SUMM)

and market_code_ in
(select bgmc from ifsinfo.PCUK_GROUP_ALLOC_SUMM);


If I point the PL/SQL to a table it seems to work ok. So I presume the problem is with the view.

The error I am getting when the procedure runs is

table IFSAPP.CUSTOMER_ORDER_TAB is mutating, trigger/function may not see it.

Does anybody have any clues what the error means or what would cause it so I can investigate further!

Thanks

Steve
Re: PL/SQL mutating error (IFS) [message #564562 is a reply to message #564561] Sat, 25 August 2012 14:44 Go to previous messageGo to next message
BlackSwan
Messages: 21967
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>The error I am getting when the procedure runs is
Oracle errors come with error number & message; like ORA-01555 Snapshot too old

I'll speak only for myself.
I rarely can debug code I can not see.

consider posting FORMATTED procedure back here
Re: PL/SQL mutating error (IFS) [message #564564 is a reply to message #564561] Sat, 25 August 2012 14:46 Go to previous message
Michel Cadot
Messages: 57644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Mystery Stories: Oracle's Mutating Tables

Regards
Michel
Previous Topic: building dynamic SQL insert statement
Next Topic: want to commit by changes in database after second transaction?
Goto Forum:
  


Current Time: Thu Apr 24 02:09:52 CDT 2014

Total time taken to generate the page: 0.15253 seconds