On a 184.108.40.206 there was a strange CLOB to VARCHAR2 conversion bug which produced garbage when the SQL statement of a tabular form was converted to VARCHAR2.
This was not reproducible on 10g.
Workaround: Instead of an implicit conversion use SUBSTR(xxx, 1, 32767). That will do it.
Log in to post a comment.