Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database trigger: bad bind variable 'NEW'
Rejean:
The problem may be that "new" is a reserved word. Try changing the name and see if that changes anything.
Tom
Rejean Carrier <rejean.carrier_at_informatiquell.ca> wrote in message
news:fW715.51$UM2.3417_at_weber.videotron.net...
> 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
![]() |
![]() |