| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: What happens if...
If dont have "set stoponerror on" it works with the next statement.
Only the one insert was discarded.
Andy wrote:
> Hi,
>
> What happens if I am running an "insert" query in SQL*PLUS against a
> table and I encounter a unique constraint violation? Does the query
> just skip the insert on the row that encountered the unique constraint
> violation and continue with the insert for the next row, or does the
> query stop at the point that the violation occurred and go no further?
>
> I know you get the error:
> ERROR at line 1:
> ORA-00001: unique constraint (FRT.PK_FREIGHT) violated
> but I can't tell if the query ends at this point or continues on.
>
> Hope I explained that ok...thanks!
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
--
 |
 |