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
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