Can't answer part 1, but on part 2, I believe the following note would apply since you are using DBI version 1.34:

LOB Locator Methods

The following driver-specific methods let you manipulate "LOB Locators
+". LOB locators can be selected from tables directly, if the ora_auto
+_lob attribute is false, or returned via PL/SQL procedure calls.

(If using a DBI version earlier than 1.36 they must be called via the 
+func() method. Note that methods called via func() don't honour Raise
+Error etc, and so it's important to check $dbh->err after each call. 
+It's recommended that you upgrade to DBI 1.38 or later.)

[download]

Scott

Note You may want to look into the really old version of DBD::Oracle (1.06 versus current version 1.17) as possibly part of your issue with part 1, the changelogs between 1.06 and 1.17 have references to the LOB stuff you are using.

In reply to Re: Oracle DBI CLOB Issue: fetch Column TRUNCATED by helphand
in thread Oracle DBI CLOB Issue: fetch Column TRUNCATED by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.