Re: Deleting with Instead Trigger in Oracle 8i

From: Howard Rogers <aldeburgh_at_bigpond.com>
Date: Wed, 16 Apr 2003 19:52:22 +1000
Message-ID: <Fy9na.15530$1s1.247706@newsfeeds.bigpond.com>

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7038F8835_at_lnewton.leeds.lfs.co.uk...
> Evening Howard,
>
> put the Christmas Card list away !!!
>
> >> I might need practice in reading triggers, but as I read your code,
> it goes
> >>'If inserting.... updating... elsif deleting...'
> >> Strikes me that the updating part of the code gets executed
> regardless of
> >> what you're actually doing... but I could be wrong.
>
> No, the OP was correct, he had 'if inserting ... elsif updating ....
> elsif deleting ... end if' which is fine. Obvioulsy the final elseif
> could be an else on the grounds of no more options though !

Oh well. Could have sworn there was no 'elsif updating'. But there you go... as I said, I knew you'd see it!

Cheers.
HJR
(Remind me not to do PL/SQL posts in the future). Received on Wed Apr 16 2003 - 04:52:22 CDT