There must be some difference in the structure of the table.
What is the structure( Columns Variable & length) of table
qte_expeidtion & table qtexp_contract. Try to give without alias refop.

Regards


-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x6493995.[Email address protected]
Sent: Wednesday, August 08, 2007 4:44 PM
To: LazyDBA Discussion
Subject: ORA-01036: illegal variable

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




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page