Re: External tables - rejected rows

Chuck wrote:

Rejected rows aren't included in the count, so the difference would
always be 0.

No, I meant something like:

select count(*) into external_table_count from external_table;

Then, after your insert:

rejected_rows = external_table_count - sql%rowcount

.