Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: External tables - rejected rows

Re: External tables - rejected rows

From: <fitzjarrell_at_cox.net>
Date: 31 May 2006 09:38:00 -0700
Message-ID: <1149093480.144340.114480@h76g2000cwa.googlegroups.com> 






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




I hate to ask but are you asking about the rows rejected by your insert
process or the rows rejected when the external table was loaded?




David Fitzjarrell
Received on Wed May 31 2006 - 11:38:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US