Re: SQL Loader automation

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Tue, 23 Feb 1999 11:05:08 +0000
Message-ID: <36D28B64.F0C0CEFF@rdbms.freeserve.co.uk>

John,

The Oracle8i documentation comments on the availability of the SQL*Loader API.

Chris

"John F. Keaveney" wrote:
>
> We have an application which periodically sweeps text files into an
> Oracle database by executing SQL Loader. We have had some
> issues since, without parsing the log file, we don't know if SQL Loader
> succedded or failed. The presence of a bad file is not enough of an
> indicator. Will there be an API to SQL Loader? Has anyone found
> an elegant way to monitor the results of SQL Loader in an automated
> fashion?
> We are hesitant in parsing the log file due to the reliance on the log
> file format and changes. We don't have a spec which says 'here is
> everything that can appear in a log file'.
>
> Thanks,
> John
Received on Tue Feb 23 1999 - 05:05:08 CST