Re: What's wrong with the trigger?
From: Rod Stewart <rod.stewart_at_afp.gov.au>
Date: Thu, 20 Aug 1998 14:35:55 +1000
Message-ID: <6rg8rk$s6e$1_at_plutonium.sge.net>
Date: Thu, 20 Aug 1998 14:35:55 +1000
Message-ID: <6rg8rk$s6e$1_at_plutonium.sge.net>
You can not use 'commit' in a trigger - it will commit anyway.
Violin wrote in message <35df7a8f.5691513_at_news.twsc.pouchen.com.tw>...
> UDPATE MORDER SET ORD_ISS = accept_temp
> WHERE (ORD_NO = :new.ord_no AND
> ORD_NUM = :new.ord_num);
> END IF;
> COMMIT;
>END INS_ACCEPT;
>/
>
>But when I compile the script in SQL*Plus,there's an error:
>Warning: Trigger created with compilation errors.
>What's wrong with my trigger?
>Please give me some tips,Thank you in advance!
>Please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
Received on Thu Aug 20 1998 - 06:35:55 CEST