write your own sqlldr using OCI! (or better yet, use the DBI extension for
perl)
You kill two birds with one stone-> perl will easily parse the text files
->DBI will shove it up
oracles tables
John F. Keaveney <johnkeaveney_at_targusinfo.com> schreef in artikel
<7asqt1$f2d$1_at_news1-alterdial.uu.net>...
> 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 - 03:00:53 CST
