Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "ORA-01461: can bind a LONG value only for insert into a LONG column" while running an event in DIH
Problem Description
In Data Integration Hub (DIH), while running an event, the following error is displayed: 

ORA-014​61: can bind a LONG value only for insert into a LONG column​
Cause
This issue occurs if you attempt to insert data having MBCS characters into a Varchar2 column.

This would not work as those characters (for instance, Chinese or Japanese characters) cannot be directly inserted as LONG, LONG RAW datatypes.

Solution
To resolve this issue, after making sure that the value being inserted in are having MBCS and are correct, change the datatype of the column in question to CLOB datatype.

This would not affect the DIH services as the alteration only needs to be done to the staging database and the data would not be lost in anyway.
More Information
Applies To
Product: Data Integration Hub
Problem Type: Performance
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/24/2019 10:03 PMID:565698
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)