Home » RDBMS Server » Server Administration » Mutating table error
Mutating table error [message #370647] Fri, 14 January 2000 14:13 Go to next message
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 Go to previous message
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
Previous Topic: Re: First day of the FINNISH week
Next Topic: Calling sendmail within SQL or PL-SQL
Goto Forum:
  


Current Time: Thu Mar 28 17:44:16 CDT 2024