Re: PLSQL - handling errors when using an implicit cursor
From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 1 Jul 2011 10:56:30 +0800
Message-ID: <BANLkTimn17G8YCWGSAiGsJ8d0ZVginSgmA_at_mail.gmail.com>
On Thu, Jun 30, 2011 at 5:57 AM, rjamya <rjamya_at_gmail.com> wrote:
Date: Fri, 1 Jul 2011 10:56:30 +0800
Message-ID: <BANLkTimn17G8YCWGSAiGsJ8d0ZVginSgmA_at_mail.gmail.com>
On Thu, Jun 30, 2011 at 5:57 AM, rjamya <rjamya_at_gmail.com> wrote:
> DML error logging (as mentioned below) is your best and easiest option.
>
> Raj
>
>
> On Wed, Jun 29, 2011 at 4:39 PM, Rumpi Gravenstein <rgravens_at_gmail.com>wrote:
>
>> Have a look at
>> http://www.oracle-base.com/articles/10g/DmlErrorLogging_10gR2.php
>>
>>
Alternatively, wrap the thing as a BULK BIND and use the SAVE EXCEPTIONS clause
Cheers
Connor
-- Connor McDonald =========================== email: connor_mcdonald_at_yahoo.com web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 30 2011 - 21:56:30 CDT