| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Before insert trigger, weird problem
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
 |
 |