[Patrick Has successfully completed the online course Introduction]

9 months ago #43248

Hi, in an Oracle database, we have a table with a CLOB column. How to read strings longer than 4.000 characters via a SQL connector without getting the error message “ORA-00932: inconsistent datatypes”?

We tested String and Any. Trying to convert the value with to_char fails with a buffer error message.

[Armin Winkler Has successfully completed the online course IntroductionHas successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)Has successfully completed the online course Basics (100)]

9 months ago #43492

Up

0

Down

::

Hi Patrick,

 

this seems to be a bug in the SQL connector. It should not matter how many characters the data selected from a CLOB column has, so I would consider this an unintended behaviour of the connector. Which Simplifier version are you currently using? Should the error persist even on the latest Simplifier 8.x release, would it be possible for you to create a support ticket in our portal for this matter, so we can analyze your error in greater detail and handle the communication with you separately? If you don’t have access to our support portal, please let us know here so we can create an internal ticket on behalf of you and update you about the bugfixing progress in this topic.

 

Thank you in advance and kind regards,

 

Armin