Home » RDBMS Server » Server Utilities » SQL*Loader-704: Internal error: ulmtsyn: OCIStmtExecute(tabhp) Ý1480¨
icon5.gif  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
Previous Topic: ORA-1882 on Import Oracle 9.2.0.6
Next Topic: does 'entier database' import will alter existing sys password.?
Goto Forum:
  


Current Time: Thu Dec 08 16:30:54 CST 2016

Total time taken to generate the page: 0.12707 seconds