Re: When has Loader finished?

tim_bedford_at_my-deja.com wrote:
>
> Hi,
> I've got a C++ application that gets an ASCII file, uses Loader to
> squirt it into an Oracle table, and then compares it with another table
> in a search. The trouble is I can't figure out how to get the C++ app to
> know when Loader has finished doing its stuff. If I try and do the
> search immediately after calling Loader it gets nothing, understandably.
> The only thing I can think of is to count the number of lines in the
> ASCII file, then do a COUNT on the table, and not perform the search
> until they're the same. But there's got to be a better way than that.
> tahnks,
>
> Tim
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

You could repeatedly query the output log file for number of rows loaded..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

(Apologies for not replying to any emails - YAHOO have a dead server)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy