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