Re: SQL loader

Originally posted by robinspa
> I have written some code in VBA which formats data in excel, saves it
> as a csv and then runs a batch file to load it into an oracle
> database. My problem is I need to know when the loading process has
> finished so I can continue the code after the load has finished. Is
> there an easy way to do this?

Hello,
I've nver done it myself, but I think you can look for sqlldr exit codes:

all rows load successfully - EX_SUCC
all/some rows rejected - EX_WARN

Take a look at Oracle8i/9i Utilities.

Hope it helps.
Peter S.

--
Posted via http://dbforums.com