Re: EXCEPTIONS INTO clause

From: Thomas J Kyte <tkyte_at_us.oracle.com>
Date: 1996/04/05
Message-ID: <4k3aa4$hqv_at_inet-nntp-gw-1.us.oracle.com>#1/1


chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:

>How does this clause work? Is it only used when enabling/creating a
>constraint to let you know what rows will be trouble makers? Or is it
>used to store the trouble makers that you try to update/insert?
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
 

>If at first you don't succeed, skydiving isn't for you.

It is only used when enabling/creating a constraint to let you know what rows are the trouble makers. It does not do it for subsequent inserts/updates, they are rejected immediately without ever making it into the table.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government



opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Fri Apr 05 1996 - 00:00:00 CEST

Original text of this message