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 a Record

Re: Delete a Record

From: Paul Quenneville <paulq_at_rogers.com>
Date: Fri, 01 Feb 2002 16:05:31 GMT
Message-ID: <f1z68.14442$bIE.6069@news1.bloor.is>


key-delrec

 if condition then
 null;
else
delete record
end if;
"Massimiliano" <melidoro_at_next.fi.it> wrote in message news:%Uw68.16712$3J1.518271_at_news2.tin.it...
> I use the WHEN-REMOVE-RECORD trigger to check that the current record
> doesn't affect others record .
> If it doesn't affect any other record I can delete it , in the other case
> no. I try to use abort_query to stop the delete, but the record is always
> deleted.
> What can I try again?
>
>
Received on Fri Feb 01 2002 - 10:05:31 CST

Original text of this message

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