Re: External tables - rejected rows

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Wed, 31 May 2006 17:05:43 GMT
Message-ID: <H1kfg.2503$hv1.224@trnddc01>

fitzjarrell_at_cox.net wrote:
> Chuck wrote:

>> I'm loading data into a table by inserting rows from an external table.
>> I can easily determine the number of rows inserted in pl/sql by looking
>> at the sql%rowcount attribute after the insert completes. Is there a way
>> to easily get the # of rejected rows in pl/sql?
>>
>> Thanks

>
> I hate to ask but are you asking about the rows rejected by your insert
> process or the rows rejected when the external table was loaded?
>
>
> David Fitzjarrell
>

Rejected by the oracle_loader as the external table is being read.

I failed to mention this is 9i and IIRC anything that the INSERT chokes on will cause the entire statement to fail. Received on Wed May 31 2006 - 12:05:43 CDT