Re: External tables - rejected rows

From: gazzag <gareth_at_jamms.org>
Date: 1 Jun 2006 02:11:28 -0700
Message-ID: <1149153088.800271.211870@u72g2000cwu.googlegroups.com>

Mark C. Stock wrote:
> rejected rows are not expsed via the external table, because they were,
> well, rejected.

Perhaps I'm not making myself clear. I'll try again:

The number of rows rejected during the insert = (total number of rows in the external table) MINUS (sql%rowcount after the insert)

In other words, knowing how many rows are in the external table (select count(*) into external_table_rowcount from <external_table>;), together with the number of rows inserted (sql%rowcount), it is quite easy to calculate how many rows were rejected during the insert. Received on Thu Jun 01 2006 - 04:11:28 CDT