Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Character encoding in Oracle Service Bus

3376635Nov 6 2019 — edited Jan 6 2020

Hi, I am trying to get the first 2000 characters of a specific field in a form to use it for creating a new form via ODI-OSB. In ODI, the string was successfully trimmed down to VARCHAR2 (2000) and was stored in the database. However, when OSB tries to create the form it returns an error saying that the field is more than 2000 characters. Currently we are using utf-8 in the XQuery. Any suggestions?

Comments

Post Details

Added on Nov 6 2019
13 comments
2,595 views