Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Database trigger: bad bind variable 'NEW'
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 CDT