Sql Loader question.
475908May 22 2006 — edited May 23 2006Hello,
I am not sure of posting a Sql Loader question in this section, but I need help in solving an error which I am getting when I tried to load data into a table using sql loader.
The Table is :
1 CREATE TABLE FundNetwork
2 (
3 Fund_Family_Name varchar(60) NULL,
4 Fund_Family_Grouping_Code varchar(25) NULL,
5 Fund_Family_Number varchar(20) NULL,
6 Fund_Name varchar(60) NULL,
7 Multiple_ClassCode varchar(35) NULL,
8 Cusip varchar(10) NULL,
9 Fid_Fund_Ind varchar(20) NULL,
10 Retail_NTF varchar(20) NULL,
11 Retail_Status varchar(20) NULL,
12 FIAG_Status varchar(20) NULL,
13 NFCS_Status varchar(20) NULL,
14 Eligible_for_New_Sale varchar(25) NULL,
15 Eligible_for_Subsequent_Sale varchar(35) NULL,
16 Sec_Class_Code varchar(20) NULL,
17 QIA_Only varchar(20) NULL,
18 Trading_Symbol varchar(20) NULL,
19 Investment_Objective varchar(50) NULL,
20 Class_of_Shares varchar(20) NULL,
21 Load_Charge number(8,4) NULL,
22 Load_Type varchar(20) NULL,
23 Networking_Indicator varchar(20) NULL,
24 Total_Assets number(12,4) NULL
25* )
When I tried to load the data,
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- -------------
FUND_FAMILY_NAME FIRST * , CHARACTER
FUND_FAMILY_GROUPING_CODE NEXT * , CHARACTER
FUND_FAMILY_NUMBER NEXT * , CHARACTER
FUND_NAME NEXT * , CHARACTER
MULTIPLE_CLASSCODE NEXT * , CHARACTER
CUSIP NEXT * , CHARACTER
FID_FUND_IND NEXT * , CHARACTER
RETAIL_NTF NEXT * , CHARACTER
RETAIL_STATUS NEXT * , CHARACTER
FIAG_STATUS NEXT * , CHARACTER
NFCS_STATUS NEXT * , CHARACTER
ELIGIBLE_FOR_NEW_SALE NEXT * , CHARACTER
ELIGIBLE_FOR_SUBSEQUENT_SALE NEXT * , CHARACTER
SEC_CLASS_CODE NEXT * , CHARACTER
QIA_ONLY NEXT * , CHARACTER
TRADING_SYMBOL NEXT * , CHARACTER
INVESTMENT_OBJECTIVE NEXT * , CHARACTER
CLASS_OF_SHARES NEXT * , CHARACTER
LOAD_CHARGE NEXT * , CHARACTER
SQL string for column : "to_int(:Load_charge)"
LOAD_TYPE NEXT * , CHARACTER
NETWORKING_INDICATOR NEXT * , CHARACTER
TOTAL_ASSETS NEXT * , CHARACTER
SQL string for column : "to_int(:Total_Assets)"
value used for ROWS parameter changed from 64 to 45
Record 1: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
ORA-00904: "TO_INT": invalid identifier
Record 2: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
ORA-00904: "TO_INT": invalid identifier
Record 3: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
ORA-00904: "TO_INT": invalid identifier
Record 4: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
ORA-00904: "TO_INT": invalid identifier
Record 5: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
ORA-00904: "TO_INT": invalid identifier
Record 6: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
ORA-00904: "TO_INT": invalid identifier
Record 7: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
Any Help would be appreciated.