Deleting with Instead Trigger in Oracle 8i

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 16 Apr 2003 11:50:39 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7038F967D@lnewton.leeds.lfs.co.uk>

-----Original Message-----
From: Howard Rogers [mailto:aldeburgh_at_bigpond.com] Posted At: Wednesday, April 16, 2003 10:52 AM Posted To: server
Conversation: Deleting with Instead Trigger in Oracle 8i Subject: Re: Deleting with Instead Trigger in Oracle 8i

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

Took me a while and an example. I made the same mistake in using :new rather than :old and sure enough, I got the 'n rows deleted' message, but nothing was deleted. Then I spotted the 'obvious' error :o).

>> (Remind me not to do PL/SQL posts in the future).
Nah, when you post something that is incorrect, someone will [gently] advise you. Hell, why do you think I post replies - I learn more that way :o)

Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Wed Apr 16 2003 - 05:50:39 CDT