Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04091 table string.string is mutating, trigger/function may not see it

354254Nov 24 2003 — edited Nov 24 2003

When I am tending to delete something from my table I received this message.
I defined a PL/SQL function reads data from that table. Is that meaning I could not modify anything in table once I have some PL/SQL defined on that? It sounds ridiculour. Or I missed some points?
Anyone could help me out?

Many thanks,
Qiang

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2003

Added on Nov 24 2003

#general-database-discussions

6 comments

232 views