DBD::Oracle - OCILobRead error

Samy_rio has asked for the wisdom of the Perl Monks concerning the following question:

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';

Comment on DBD::Oracle - OCILobRead error Select or Download Code

Replies are listed 'Best First'.
Re: DBD::Oracle - OCILobRead error by almut (Canon) on Apr 29, 2009 at 10:19 UTC
I've encountered similar problems when LongReadLen was set too small...	[reply]
Re^2: DBD::Oracle - OCILobRead error by Samy_rio (Vicar) on Apr 29, 2009 at 12:52 UTC
I assigned the LongReadLen value like below and also i got the exact length, eventhough i am getting the same error. `my $new_sql = <<EOS; select <col_name> from <table_name> EOS $dbh->{LongReadLen} = $dbh->selectrow_array(qq{ SELECT dbms_lob.getlength(<col_name>) FROM <table_name> }); print "CLOB Length: ".$dbh->{LongReadLen}; my $sth = $dbh->prepare($new_sql); $sth->execute(); my @rows; while(my $cols = $sth->fetchrow_hashref()) { push(@rows, $cols); } $sth->finish();` [download] Anything wrong in that? Regards, Velusamy R. eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@\|6%,53!-9@2~j';	[reply] [d/l] [select]
Re^3: DBD::Oracle - OCILobRead error by runrig (Abbot) on Apr 29, 2009 at 16:09 UTC
Just set it to an arbitrarily large value: `$dbh->{LongReadLen} = 10241024; # or even another 10244` [download]	[reply] [d/l]
Re: DBD::Oracle - OCILobRead error by marto (Cardinal) on Apr 29, 2009 at 10:16 UTC
The version of DBD::Oracle you are running is from 2006, looking at the list of current Changes file, some work has been done around this area over the years. Also, which versions of Perl and Oracle are you working with? Hope this helps Martin	[reply]
Re^2: DBD::Oracle - OCILobRead error by Samy_rio (Vicar) on Apr 29, 2009 at 10:40 UTC
currently i am working in x86_64 x86_64 x86_64 GNU/Linux, Kernal: 2.6.9-67.ELsmp `Perl Version: 5.8.5 built for x86_64-linux-thread-multi Oracle 9i Oracle Client : 9.2.0.1.0` [download] Updated Also i tried these oracle version also `Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit` [download] Regards, Velusamy R. eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@\|6%,53!-9@2~j';	[reply] [d/l] [select]


P is for Practical
	PerlMonks