#75 Strange CLOB to VARCHAR2 conversion bug in Oracle 9i

v1.7
closed-fixed
Patrick Wolf
5
2014-08-15
2007-08-12
Patrick Wolf
No

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.

Discussion

  • Patrick Wolf
    Patrick Wolf
    2007-08-12

    Logged In: YES
    user_id=1449836
    Originator: YES

    Fixed in release 1.7

     
  • Patrick Wolf
    Patrick Wolf
    2007-08-12

    • milestone: --> v1.7
    • summary: Strange CLOB to VARCHAR2 convertion bug in Oracle 9i --> Strange CLOB to VARCHAR2 conversion bug in Oracle 9i
    • status: open --> closed-fixed