Re: External tables - rejected rows

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 Received on Wed May 31 2006 - 11:03:16 CDT