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-12899: value too large for column COLUMN_NAME(actual: 2000, maximum: 4000)" when writing to an Oracle column with NCLOB datatype
Problem Description
The following error is seen for multiple columns have NCLOB datatype in the source:

ERROR: Database errors occurred: 
ORA-12899: value too large for column COLUMN_NAME (actual: 2000, maximum: 4000)
Database driver error...

Even though DBMS_LOB.SUBSTR function is used to trim the characters at the source itself, the error is still seen.
The precision at the target is set to higher than the characters being read from the source.

Cause
This issue is caused due to an unsupported database version for the source.
When the data is read from unsupported source and it runs the DBMS_LOB.SUBSTR function, due to Oracle version compatibility issues, this might be done incorrectly and hence, errors are seen in the session.
Solution
Use a supported source/target database to resolve the issue.
More Information
Applies To
Product: PowerCenter
Problem Type: Product Feature
User Type: Developer; Administrator
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/8/2020 1:11 AMID:625875
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)