Before Update

[roche786]

Hi,

I am trying to write a before update trigger , which should before updating the current table should take all the old values and insert it into an audit table.

I wrote this but its giving compilation error please let me know where I am going wrong.


create or replace trigger tbl_update
before update on tbl_update
for each row

begin

insert into TBL_update_AUDIT(a,b,c)

values

old.a,ld.b,'u');

end;

Kindly advice.

Thanks

 

[Beilstwh]

You must have unique object names within a schema. If your table is called tbl_update, then you must use a different unique name for the trigger.

create or replace trigger tbl_update_t1
before update on tbl_update
for each row

begin

insert into TBL_update_AUDIT(a,b,c)
values
old.a,ld.b,'u');

end;

Bill
Oracle DBA/Developer
New York State, USA

 

[roche786]

Sorry I mistyped the name it is unique and called tbl_update_trg .

It still gives compilation error.

The trigger should move the row being updated on to the audit table and should update the values in the current table.

Thanks for the help.

 

[BJCooperIT]

Could you post the error?

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus

 

[roche786]

PLS-00049: bad bind variable 'OLD.a'


Thanks

 

[BJCooperIT]

Does tbl_update have a column "a"?

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus

 

[dbomrrsm]

CREATE OR REPLACE TRIGGER t_t2_audit
AFTER UPDATE 
ON t2 
REFERENCING NEW AS n OLD AS o 
FOR EACH ROW

BEGIN
   INSERT INTO changes
   VALUES (:n.x, :o.x, user); 
END t_t2_audit;
/

UPDATE t2
SET x = 1;
COMMIT;

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[roche786]

Thanks for the help.

It worked!