OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Trigger to audit..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trigger to audit.. [message #372332]

Fri, 02 February 2001 15:02

ash
Messages: 43
Registered: February 2001

Member

trigger body:
create trigger test
before update on type
on ecsidb.cs_servers_save
for each row
begin
insert into ecsidb.cs_servers_audit(type)
values(:old.type)
end;

I am getting compilation errorr that expecting ; at END
Any help is appreciated

Report message to a moderator

Re: Trigger to audit.. [message #372334 is a reply to message #372332]

Fri, 02 February 2001 15:24

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

try adding a ';' after the insert statement

you might also think of including a check that :old.type != :new.type before inserting ???

Report message to a moderator

Re: Trigger to audit.. - URL : Audit individual fields [message #372336 is a reply to message #372332]

Fri, 02 February 2001 15:41

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=59412348055

Report message to a moderator

Previous Topic:	CONNECT BY CLAUSE
Next Topic:	Create Datafile Automatically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 10:53:33 CDT 2024