Re: SQL Loader Window Won't Close

Hi,

This is a known problem in SQLLoader from Oracle 8.0.x. SQL Loader imports all data successfully but does not return to the prompt.

To solve the problem you need to upgrade your client to Oracle 8i (8.1.x). Oracle 8.0.x is not certified for Windows 2000 and unexpected things can happen. This might be one of them.

Best regards, Dmitry

--
SQLWays - Database migration software for IBM DB2, Oracle, SQL Server,
Sybase and MySQL.
www.ispirer.com


"Kimberly Lord" <lordkimberly_at_worldnet.att.net> wrote in message
news:_1iZ9.6165$rq4.557742_at_bgtnsc05-news.ops.worldnet.att.net...


> Hi,

>     I am calling the sqlldr80.exe from a vb exe using the shell command.


> Everything is working ok except the dos sql loader window stays open.  I

> don't know what is causing this.  If  I call the loader from start, run

the


> same thing happens.  What kind of command closes the sql loader.Here is


the


> control file I am using:


>

> load data

> infile

>

'D:\CODARVectorData\Predictions\2003\January\21\04\Tot_FRNT_03-01-21_0400_25


> F.dat'

> Append into table PREVECTORDATARECS

> fields terminated by ','

> (

> FK_VECTORID,

> LONGITUDE,

> LATITUDE,

> U,

> V,

> UPRIME,


> VPRIME,

> SITESUSED

> )

>

> The vb exe runs hourly on a windows2000 server.  So it is not possible to

> manually close the windows.

> Pleas offer any suggestions.

> Thanks,

> Kim

>

>