Re: Infinite Loop using SQLLDR

When I used SQLLDR in the .ctl file I did specify the type of each field, and it works good, look in oracle books for the specification of the fields.

<bernardkbe_at_my-deja.com> ha scritto nel messaggio news:95qoth$mv9$1_at_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 - 03:59:31 CST