Re: When has Loader finished?

The important question is how'r you calling sql loader to load the table. Are you calling it inside your C++ program or outside ? If inside then I cannot see a problem, if you are somehow starting sqlloader outside of C++, use a simple record delimiter concept, put a stupid marker and check for its existence. Though this is horrible since you waste CPU cycles.... Plus give more information as to what platform, compiler, version and .. such if you need an answer.

<tim_bedford_at_my-deja.com> wrote in message news:8vea2u$p8f$1_at_nnrp1.deja.com...
> 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.
Received on Sun Nov 26 2000 - 03:27:42 CET