| Mutating table error [message #370647] |
Fri, 14 January 2000 14:13  |
Sreenivas
Messages: 15
Registered: January 2000
|
Junior Member |
|
|
Hi Every one on Board ,
I am having problems in Updating a table which has a
Insert / Update row level trigger on that table.
Inside the trigger body its calling a package,
where its again quering the trigger table .
I know 2 solutions for it as far as my knowledge is concern .
1)
a) Creating a Package with PL/SQL table of record data type
b) create a row level trigger and populate the PL/SQL table with OLD & NEW values
c) create a statement level trigger and update the table with values
2) Using DBMS_PIPES creating a session and killing the session ( which is more complex as I guess)
Both the above ones works fine, apart from these ones
I am curious to know are there any other methods to get rid of this problem.
If any of you guys know this , I want to get the info
Thanks a lot in advance,
Sreeni
|
|
|
|
| Re: Mutating table error [message #370653 is a reply to message #370647] |
Sun, 16 January 2000 23:54  |
Rajaganapathy Mohan
Messages: 5
Registered: January 2000
|
Junior Member |
|
|
Hai Sreenivas,
Iam sorry i don't know the solution for your
problem.But can you tell me more about the first option where you create a pl/sql table and use
a statement level trigger instead of a row level
trigger.........
Rgds,
Mohan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
