Re: External tables - rejected rows


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

The rejected rows will be placed in a .bad file. You can create an
external table (with column definitions like varchar2(4000) so that
you can query it) and do a count(*) on it.
Or you can probably create an external table on the log file and
query that.

Anurag

.

Relevant Pages

  • Re: External tables - rejected rows
    ... I can easily determine the number of rows inserted in pl/sql by looking ... The rejected rows will be placed in a .bad file. ... you can query it) and do a counton it. ... Or you can probably create an external table on the log file and ...
    (comp.databases.oracle.server)
  • Re: Conversion of Business Objects to Flat Data Table and Viceversa
    ... I have PL/SQL query which returns all the fields. ... implementation for each business objects ... The problem is that for every child object in your heiarchy, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Weird performance issue ....
    ... If I understand - the problem is with a query returned from a stored proc ... "a query making a user function call" you mean something different again). ... as PL/SQL is assumed to be a "batch" environment. ... Not taking about power since where the issue is, the server ...
    (comp.databases.oracle.server)
  • Re: ResultSet within ResultSet
    ... Another alternative would be to run the query: ... > I did that how would I get my object model built up in the Java? ... You can't get PL/SQL to build Java objects for you on the client. ...
    (comp.lang.java.databases)
  • signature based IDS/IPS effectiveness
    ... How effective are signature based IDS/IPS systems on text based ... protocols which involves grammar like PL/SQL. ... query patterns. ... So does not that mean stateless signature based IDS/IPS ...
    (Focus-IDS)