Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete on Multiple Tables

Re: Delete on Multiple Tables

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 12 Nov 2005 17:10:49 +0100
Message-ID: <dl53kb$vm7$1@news6.zwoll1.ov.home.nl>


Maxim Demenko wrote:

> bdbafh_at_gmail.com schrieb:

>> create trigger tbd_tablea
>> before delete on tablea
>> for each row
>> begin
>> delete clause for table b;
>> delete clause for table c;
>> commit;
>> exception handler;
>> end;
>>
>>
>> kinda short, but I gotta run.
>> I'll bet that Dan Morgan has some examples up on his site.
>>
>> -bdbafh
>>
> 
> You mean it not really, do you?

>> *commit*;
> 
> Best regards
> 
> Maxim

No - he actually knows it will throw the "cannot commit in a trigger" error - he is just teasing :8
-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Nov 12 2005 - 10:10:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US