SQL*Loader-704: Internal error: ulmtsyn: OCIStmtExecute(tabhp) Ý1480¨ [message #236057] |
Tue, 08 May 2007 21:05 |
HIMULE
Messages: 8 Registered: May 2007 Location: Pleasanton, CA
|
Junior Member |
|
|
Hi!
I am trying to load an oracle table using the SQL Loader. I created a control card uisng the position and length of the field.
Partial code looks as follows in SQL Loader;
,DIV_CD POSITION(004) CHAR(001)
,SERV_NBR POSITION(005) CHAR(013)
,SERV_POST_DT POSITION(018) DATE 'YYYYMMDD'
,POSTED_SVC_SEQ_ID POSITION(026:35) INTEGER EXTERNAL
"DECODE(SUBSTR(:POSTED_SVC_SEQ_ID),1,1),NULL,
LTRIM(:POSTED_SVC_SEQ_ID),
:POSTED_SVC_SEQ_ID)"
,SERV_TYPE_CD POSITION(036) CHAR(001)
And the partial definition I used to create the table for the corresponding fields are as follows;
SERV_NBR CHAR(13) NOT NULL,
SERV_POST_DT DATE NOT NULL,
POSTED_SVC_SEQ_ID DECIMAL(09,0) NOT NULL,
SERV_TYPE_CD CHAR(01) NOT NULL,
I ran my load job and got the following message;
SQL*Loader-704: Internal error: ulmtsyn: OCIStmtExecute(tabhp) 1480¨
ORA-01480: trailing null missing from STR bind value
I already checked the syntax and they seem to be correct. I think the problem is with the field POSTED_SVC_SEQ_ID. I defined it in the table as DECIMAL(9,0) but the actual file has a null or space before the 9 digit no.
Please advise on what strategy should I use.
Thanks,
Hazel
|
|
|