gazzag 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
>
> Do a row count on the external table then subtract sql%rowcount after
> your insert?
>
> HTH
>
> -g
>
Rejected rows aren't included in the count, so the difference would
always be 0.
Received on Wed May 31 2006 - 11:18:19 CDT
