| PL/SQL mutating error (IFS) [message #564561] |
Sat, 25 August 2012 14:31  |
 |
SteveShephard
Messages: 25
Registered: August 2012
|
Junior 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
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
