Before insert trigger, weird problem

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;

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