Problems with trigger creation

From: Stan Brown <stanb_at_panix.com>
Date: Tue, 13 May 2003 14:33:19 +0000 (UTC)
Message-ID: <b9qvnf$fc3$2@reader1.panix.com>

I'm tring to add a new atble, and it's associated indexs, and trigger to an existing instance. The trigger creation is failing with the following error message:

create or replace trigger TEST_TRIG

                          *

ERROR at line 1: ORA-04082: NEW or OLD references not allowed in table level triggers

Here is the syntax I'm using:

create or replace trigger TEST_TRIG
before insert on SUBVOLTS
declare

   l_date date;
begin
  l_date := :new.dstamp+0;

         :new.dstamp := l_date;
end;
/

Can some kind soul point out what I'm doing wrong?

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin

Received on Tue May 13 2003 - 09:33:19 CDT