(Fwd) Fetching CLOB variable fron Oracle in Perl version 5.005_03

----- Forwarded message from Sachin Bardeo -----

Subject: Fetching CLOB variable fron Oracle in Perl version 5.005_03
Date: Thu, 22 Sep 2005 12:25:19 +0530
From: "Sachin Bardeo"
To:
X-imss-version: 2.031
X-imss-result: Passed
X-imss-scores: Clean:99.90000 C:2 M:3 S:5 R:5
X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000)

Hi Tim,

Hope you are doing fine!

I am trying to fetch CLOB variable from Oracle by using DBI following are the code experts:

Packages used:

use DBI;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
use TeamSite::JavaResourceBundle;
use File::Basename;
use DBD::Oracle qw(:ora_types);



And code which fetches the Data is as follows:

my $sth = $dbh->prepare(q{
begin
:output := content_tracer.create_tree(:trace,:child_params,:parent_para ms);
end;
},{ ora_auto_lob => 0 } );
$sth->bind_param(":trace",$trace);
$sth->bind_param(":child_params",$child_params);
$sth->bind_param(":parent_params",$parent_params);
$sth->bind_param_inout(":output",\$data,50000,{ ora_type => ORA_CLOB });
$sth->execute();
$sth->finish;



But I am getting following error after execution:

DBD::Oracle::st execute failed: (DBD ERROR: LOB refetch attempted for unsupported statement type).



If I run same piece of code on Perl version 5.8.2 it is working fine. Is there a version problem?



Please help!



Thanks & Regards

Sachin



*********************************************************
Disclaimer:
The contents of this E-mail (including the contents of the enclosure(s) or attachment(s) if any) are
privileged and confidential material of MBT and should not be disclosed to, used by or copied in any
manner by anyone other than the intended addressee(s). In case you are not the desired addressee, you
should delete this message and/or re-direct it to the sender. The views expressed in this E-mail message
(including the enclosure(s) or attachment(s) if any) are those of the individual sender, except where
the sender expressly, and with authority, states them to be the views of MBT.

This e-mail message including attachment/(s), if any, is believed to be free of any virus. However, it
is the responsibility of the recipient to ensure that it is virus free and MBT is not responsible for
any loss or damage arising in any way from its use

********************************************************

----- End forwarded message -----