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
following:
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
out?
