Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External tables - rejected rows
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
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