Problems importing data into table S_OPTY which has custom column X_DESC_TEXT Varchar(4000) (Doc ID 1512854.1)

Symptoms

After reviewed EIM log file with detailed tracing the following error message has been found:

===================
DBCLog DBCLogError 1 0000b7f55016570f:0 2012-09-14 10:09:56 SQL Warning, SQL State 01000, 0, [DataDirect][ODBC Oracle driver]The currently active transaction was committed before changing the AutoCommit connection option.
SQLError Statement 0 0000b7f55016570f:0 2012-09-14 10:09:57 SQL Statement:
UPDATE SIEBEL.EIM_OPTY
   SET IF_ROW_STAT_NUM = 0,
IF_ROW_STAT = 'IN_PROGRESS',
T_OPTY__STA = 0,
T_OPTY__RID = NULL,
T_OPTY__EXS = 'N',
T_OPTY__UNQ = 'N',
T_OPTY_BU_ID = NULL,
T_OPTY_PRDEPT = NULL,
T_OPTY_BU__STA = NULL,
T_OPTY_CON__STA = NULL,
T_OPTYPOSTN__STA = NULL,
T_REVN__STA = NULL,
OPTY_X_DESC_TEXT = DECODE(OPTY_X_DESC_TEXT,NULL,NULL,RTRIM(OPTY_X_DESC_TEXT)),
OPTY_NAME = RTRIM(OPTY_NAME)
WHERE (IF_ROW_BATCH_NUM = ?)
DBCLog DBCLogError 1 0000b7f55016570f:0 2012-09-14 10:09:57 [DataDirect][ODBC Oracle driver][Oracle]ORA-00932: inconsistent datatypes: expected NUMBER got LONG
...
Error SBL-EIM-00107: ODBC error S1000:
[DataDirect][ODBC Oracle driver][Oracle]ORA-00932: inconsistent datatypes:
expected NUMBER got LONG
(native error 932)

...

===================

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.