Hi,
I am getting the DBD::Oracle error while fetching CLOB content with huge content ex. char. length 254806 (appr).
The same code is working fine for fetching CLOB content with some 45043 char. length.
The NLS_LANG is same in both client and server.

$DBD::Oracle::VERSION = '1.17';
$DBI::VERSION = "1.604"; 

DBD::Oracle::st fetchrow_hashref failed: ORA-03106: fatal two-task com
+munication protocol error (DBD ERROR: OCILobRead) [for Statement

[download]

I tried to fetch the CLOB content using Java for clarification and its extract correctly.

Please suggest me to resolve this error.
Thanks in advance.

Regards,
Velusamy R.

eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';

In reply to DBD::Oracle - OCILobRead error by Samy_rio

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.