|
-
Hi
Create or replace trigger order_hist
before insert or update of ORPSTMP,ORUSTMP,ORSTAT on orders
for each statement
begin
insert into RF_ORD_HIST
select orrfnbr,orstat,ORUSTMP from orders;
commit;
end;
/
I am getting a table mutatiion here. Let me know what to do . Will declaring teh variables help me here
Let me know
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
|