-
Hi
I get a trigger mutation
create or replace trigger RF_TEST_SHIPTO
before delete on SHIPTO
for each row
begin
if :old.STSTAT <>'P'
THEN
insert into TEST_SHIPTO select * from shipto;
end if;
end ;
/
Let me know
thanks
-
You can't insert a row in the DELET trigger. Better handle it in application. Or you need to create a view, and then insert it.
-
You can reference greate solution on the following website:
[url]http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.main[/url], then
search by mutate table or so, there you go.
Take care
-
The best way to handle these situations is to create a package. Within the package, create a table of records and two triggers: a row trigger and an "after" statement trigger. Record the data being deleted into the table of records during the row trigger processing then manipulate the database as needed in the statement trigger using the table of records. Thus no table access occurs during mutation.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|