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

Re: Before insert trigger, weird problem

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Tue, 28 Apr 1998 19:51:23 GMT
Message-ID: <35463335.6401933@www.sigov.si>


On Tue, 28 Apr 1998 09:33:25 +0200, "Timo Feickert" <Timo.Feickert_at_prompt.de.NOWHERE> wrote:

>my vote on Alex!
>
>NEW and OLD are "virtual table names" for use inside triggers
>but not bind variables.

You are wrong. :NEW and :OLD are something like PL/SQL records of the type triggering_tablename%ROWTYPE. Because of some restrictions that do not apply to reguler PL/SQL records, they are often refered as "pseudorecords". They are implemented as *bind variables* and they definitely need a colon.

The fact that Igor's trigger does compile if REFERENCING clause is used leeds me to thinking that there might be some naming mismach in his database. I would check if there is any conflicting schema/table/column named as "NEW" that can cause this naming confusion.

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Timo.Feickert_at_prompt.de.NOWHERE
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>(please remove trailing [.NOWHERE])

Regards,


Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================
The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Apr 28 1998 - 14:51:23 CDT

Original text of this message

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