Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger Help on 8.0

Trigger Help on 8.0

From: Jeffrey A. Thompson <thompsonja_at_phibred.com>
Date: Mon, 11 Jan 1999 16:37:17 -0600
Message-ID: <77du89$mi9$1@remarQ.com>


I have a trigger that compiles fine on ORACLE 7.3. I know try to migrate the code to 8.0.5 and it doesn't compile.

Here's the source:

create trigger agent_timestamp
before insert or update on agent
for each row
declare
 operuser varchar2(15);
begin
select osuser into operuser from v$session where audsid=userenv('sessionid');
:new.revised_date := sysdate;
:new.revisor := upper(operuser);

end;

Why doesn't this work on ORACLE 8.0? Received on Mon Jan 11 1999 - 16:37:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US