Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Text length limitation of 2000 characters in ODI variable
We are trying to print the output of an ODI variable in the email body. The content captured in the ODI variable is text in nature and is expected to be of a very large length. However, the result got on execution of this whole process shows that the content is getting limited to 2000 characters only.
As per the ODI user manual, the maximum length of the variable when data type chosen as “TEXT” is unlimited.
Please advise any alternatives to achieving this.
We are working with Oracle Data Integrator 12c (12.2.1) and Oracle database 12c.
Many thanks!!
Rahul
Answers
-
Which technology You are using oracle or any other technology?
cheers
Suman K
-
Everything on Oracle
-
In Topology under oracle, if you expand the datatypes option under char or varchar type check the maximum length value, If it is 2000 change that to 4000. Let me know if this helps.
Cheers
Suman K