thanks to all
i just found the solution.
its because i run it in command mode that does not accept . if i put the "
CREATE OR REPLACE TRIGGER......" in a file run it like un script it run
well....
thanks to all again.

david...





[Email address protected]
08/08/2007 15:40


Pour : DAVID.[Email address protected]
cc :
Objet : Re: SPAM-LOW: ORA-01036: illegal variable


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Have you tried to add the
"OLD AS OLD" clause???

David NGUYEN wrote:
> 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