Re: Database trigger : bad bind variable 'NEW'

Hi,

I believe that you have to pass all variables individual. :new.var1, :new.var2 like this.

THanks

Rejean Carrier wrote:

> Hi everyone,
>
> In a database trigger, i try to pass all columns of the row to a procedure
> in a package body and i have an error when i compile this :
>
> create or replace trigger CR5_0036
> before
> insert on CRCHG_NO
> for each row
>
> begin
>
> CR50035.CR5_0035(
> :new, /* P_CRCHG_NO in CRCHG_NO%rowtype, */
> WK_RESULTAT); /* P_RESULTAT in out number */
>
> <<ALaFin>>
> null;
> end;
> /
> show errors;
>
> ERROR : PLS-00049: bad bind variable 'NEW'
>
> I would think that :NEW was a rowtype !
Received on Mon Jun 12 2000 - 00:00:00 CEST