Anurag Varma 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
>
> The rejected rows will be placed in a .bad file. You can create an
> external table (with column definitions like varchar2(4000) so that
> you can query it) and do a count(*) on it.
> Or you can probably create an external table on the log file and
> query that.
>
> Anurag
>
Thats what I wanted to avoid but if it's the only way I'll have to do
it. I was hoping someone knew of a cursor attribute or v$ table that
might contain the reject count.
Received on Wed May 31 2006 - 12:12:23 CDT
