Database trigger : bad bind variable 'NEW'

From: Rejean Carrier <rejean.carrier_at_informatiquell.ca>
Date: 2000/06/12
Message-ID: <bY715.53$UM2.3942_at_weber.videotron.net>#1/1


[Quoted] 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

Original text of this message