hi experts;

i just want to create a trigger and i have this error

CREATE TRIGGER TRG_DELETE_QE BEFORE DELETE ON QTE_EXPEDITION
FOR EACH ROW
BEGIN
DELETE FROM QTEXP_CONTRACT refop WHERE
:OLD.ID_QTY_EXPEDITION = refop.ID_QTY_EXPEDITION;
END TRG_DELETE_QE;

ORA-01036: illegal variable name/number

anay ideas about this ..?

thanks

david..



Oracle LazyDBA home page