By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,972 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,972 IT Pros & Developers. It's quick & easy.

Re: can not delete data from a table which is queried in a stored procedure

P: n/a
From Oracle:

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

Cause: A trigger (or a user defined PL/SQL function that is referenced
in this statement) attempted to look at (or modify) a table that was
in the middle of being modified by the statement which fired it.

Action: Rewrite the trigger (or function) so it does not read that

Look in v$lock for any lock on that table. Is the issue still there
after you bounced the database?

Hi, folks,

Here is my example of problem,

I have a table called node_tab. The other two tables: edge_tab,
polyline_tab has foreign key constraints ( cascade on delete) relying
on node_tab.

In one stored procedure, I have a very simple query working on
node_tab to return
coordinates of node.

When I try to delete any row from node_tab, I got error message as

The headache is when I delete any record from my node table, the
system returns the following error:
ORA-04091: table NODE_tab is mutating, trigger/function may not see it
ORA-06512: at "GEOMETRY_MAP.GETTER_PAK", line 112
ORA-06512: at "GEOMETRY_MAP.GETTER_PAK", line 143

Then I tried to delete all foreign keys relying on it. It still has
the same problem. I don't have any trigger in node_tab.

I could not understand what happened to me? Is any idea to help me
Jun 27 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.