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 -> Before insert trigger, weird problem

Before insert trigger, weird problem

From: Igor Sereda <sereda_at_spb.runnet.ru>
Date: Wed, 22 Apr 1998 14:12:09 -0400
Message-ID: <353E32F9.ABC3B4BE@spb.runnet.ru>


Hello,

There's a strange problems when attempting to assign values to a newly inserted row's columns on Oracle 7.3.2 under Solaris 2.5.1 x86.

Let's say the trigger is written the following way:

create trigger triggername

	before insert on tablename
	for each row
begin
	:new.COLUMNNAME := SOME_VALUE_HERE;

end;

This trigger would not compile with errors that say something about 'bad bind variable new'.

When modify this trigger saying REFERENCING NEW AS NEW_, and addressing new row as NEW_, everything is ok.

So, what's the problem? Did i miss something? Any answer will be greatly appreciated.

Regards,
Igor

--
Igor Sereda,
ITC, Russia Received on Wed Apr 22 1998 - 13:12:09 CDT

Original text of this message

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