Re: External tables - rejected rows

"gazzag" <gareth_at_jamms.org> wrote in message news:1149092793.578944.245940_at_j55g2000cwa.googlegroups.com...
: 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
:

rejected rows are not expsed via the external table, because they were, well, rejected.

++ mcs Received on Wed May 31 2006 - 11:49:52 CDT