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

v1.7
closed-fixed
5
2014-08-15
2007-08-12
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
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks