Home » RDBMS Server » Server Utilities » !!! Urgent: Ora -1722 error
| !!! Urgent: Ora -1722 error [message #173478] |
Mon, 22 May 2006 12:06  |
puni88
Messages: 3
Registered: May 2006
Location: Boston
|
Junior Member |
|
|
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* )
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_number(:Load_charge,'99.99')"
LOAD_TYPE NEXT * , CHARACTER
NETWORKING_INDICATOR NEXT * , CHARACTER
TOTAL_ASSETS NEXT * , CHARACTER
SQL string for column : "to_number(:Total_Assets,'99999.99')"
value used for ROWS parameter changed from 64 to 45
Record 1: Rejected - Error on table FUNDNETWORK, column LOAD_CHARGE.
ORA-01722: invalid number
Record 2: Rejected - Error on table FUNDNETWORK, column TOTAL_ASSETS.
ORA-01722: invalid number
The data used for loading is 5.44 and 89766.89 for LOAD_CHARGE and TOTAL_ASSETS columns respectively.
ANY help would be greatly
|
|
|
|
|
|
| Re: !!! Urgent: Ora -1722 error [message #173489 is a reply to message #173488] |
Mon, 22 May 2006 13:04  |
puni88
Messages: 3
Registered: May 2006
Location: Boston
|
Junior Member |
|
|
Control file:
LOAD DATA
INFILE strat.txt
REPLACE
INTO TABLE FundNetwork
FIELDS TERMINATED BY ','
(
Fund_Family_Name ,
Fund_Family_Grouping_Code ,
Fund_Family_Number ,
Fund_Name ,
Multiple_ClassCode ,
Cusip ,
Fid_Fund_Ind ,
Retail_NTF ,
Retail_Status ,
FIAG_Status ,
NFCS_Status ,
Eligible_for_New_Sale ,
Eligible_for_Subsequent_Sale ,
Sec_Class_Code ,
QIA_Only ,
Trading_Symbol ,
Investment_Objective ,
Class_of_Shares ,
Load_Charge "to_number(:Load_charge,'99.99')" ,
Load_Type ,
Networking_Indicator ,
Total_Assets "to_number(:Total_Assets,'99999.99')"
)
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Jul 01 01:20:00 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
