Infinite Loop using SQLLDR

From: <bernardkbe_at_my-deja.com>
Date: Wed, 07 Feb 2001 06:11:00 GMT
Message-ID: <95qoth$mv9$1@nnrp1.deja.com>

I'm a newbie to the SQLLDR tool so bare with me. When I execute the SQLLDR program, I get a never ending loop that repeats the command line I used for executing SQLLDR. No records, errors, or logs are generated. I have to cancel out of the command to stop the loop.

Here is my control file:

LOAD DATA
INFILE 'Investment1.csv'
INTO TABLE INVESTMENT
FIELDS TERMINATED BY ","
(INVESTMENT_ID, CREATED_BY_USER_ID, CREATED_DTM, MODIFIED_BY_USER_ID, MODIFIED_DTM, INVESTMENT_NAME, COUNTRY_CD, INVESTMENT_CLASS_CD, DIVISION_ID, COMPANY_CD, INDUSTRY_CATEGORY_CD, RATING_NUM, ASSET_MANAGER_CONTACT_ID, VALIDATION_STATUS_CD)

Here is my INFILE (one line of it):

1,kevine,2/6/2001 23:18,kevine,2/6/2001 23:18,Investment Name,UNITEDS,MERCMTM,EWS,EA,OIL&GA,9,0,N

Here is my SQLLDR Command Line:

SQLLDR Userid=kevine/password, Control=Investment1.ctl, Log=investment1.log, bad=investment1.bad, discard=investment1.dsc

Here is the data types for the fields in the INVESTMENT table:

INVESTMENT_ID             NUMBER        NOT NULL,
CREATED_BY_USER_ID        VARCHAR2 (30)  NOT NULL,
CREATED_DTM               DATE          NOT NULL,
MODIFIED_BY_USER_ID       VARCHAR2 (30)  NOT NULL,
MODIFIED_DTM              DATE          NOT NULL,
INVESTMENT_NAME           VARCHAR2 (60)  NOT NULL,
DIVISION_ID               NUMBER        NOT NULL,
COMPANY_CD                VARCHAR2 (10)  NOT NULL,
ASSET_MANAGER_CONTACT_ID  NUMBER        NOT NULL,
VALIDATION_STATUS_CD      VARCHAR2 (8)  NOT NULL,
INVESTMENT_CLASS_CD       VARCHAR2 (8),
INDUSTRY_CATEGORY_CD      VARCHAR2 (8),
COUNTRY_CD                VARCHAR2 (8),
RATING_NUM          NUMBER


--------------------------------------------------------

Can anyone tell me what I'm doing wrong? Thanks in advance for your help.

Kevin

Sent via Deja.com
http://www.deja.com/ Received on Wed Feb 07 2001 - 00:11:00 CST