siebel,Siebel Exception: ORA-01461: can bind a LONG value only for insert into a LONG column

Issue:
When you are running Siebel Database Import Repository, you may got following error.

Exception:
2011-04-24 21:07:18    S1000: [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
2011-04-24 21:07:18    
2011-04-24 21:07:18    Array insert failed. Retry this array row by row ...
 
Reason:
In general, this issue will be happened when you import Repository using your own ODBC Driver Type, but not for siebel.

Solution:
Please check your ODBC setting. Your ODBC driver type should be Siebel Oracle90 X:/…/siebsrvr.
If not, please remove it and create a new one.

延伸阅读

• 2011-5-10-- invoking,Siebel Exception: SBL-BPR-00162: Error invoking service '%1', method '%2' at step '%3'.
• 2011-5-9-- siebel,Siebel Exception: The value entered in field Business Component of buscomp Repository WF Step does n
• 2011-5-11-- siebel,Siebel HOW TO: How to Deactivate Workflow
• 2008-7-31-- siebel:有了Siebel后的Oracle，会强大过SAP吗？
• 2008-7-1-- db2udb:如何将Siebel 7从DB2 UDB V8迁移到DB2 9