Strange CLOB to VARCHAR2 conversion bug in Oracle 9i
Brought to you by:
patrick_wolf,
praganitsch
On a 9.2.0.6 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.
Logged In: YES
user_id=1449836
Originator: YES
Fixed in release 1.7