Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Loader question.

475908May 22 2006 — edited May 23 2006
Hello,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2006
Added on May 22 2006
20 comments
1,080 views