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: question about plsql exceptions

Re: question about plsql exceptions

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 25 Feb 2006 13:36:35 +0100
Message-ID: <dtpi8q$d4n$1@news2.zwoll1.ov.home.nl>


stefanomnn_at_yahoo.it wrote:
> Hi! thank u for your answere!
> my aim is making N insert, in a cyvle (while or for)...
> but i have to ignore primary key violated errors (then, if an item is
> present, no problem)
> i didn't find a predefined exception, then i made so:
[snip]

On supported Oracle versions (not stated), you can use the more efficient merge into statement.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Feb 25 2006 - 06:36:35 CST

Original text of this message

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