I already set the variables.
$dbh->{LongReadLen} = 200 * 1024;
$dbh->{LongTruncOk} = 1;
Any other idea ? I really dont know if DBD::Oracle supports a out param
(about clob, other types are ok) from stored procedure.
Thanks.
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> Read the docs on LongReadLen.
>
> On 09-Dec-2003 Tim Bunce wrote:
> > ----- Forwarded message from builder developer
<[EMAIL PROTECTED]> -----
> >
> > Delivered-To: [EMAIL PROTECTED]
> > X-Originating-IP: [200.163.79.22]
> > X-Originating-Email: [EMAIL PROTECTED]
> > From: "builder developer" <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Subject: DBD::Oracle (CLOB and sp)
> > Date: Tue, 09 Dec 2003 09:04:04 -0200
> > X-OriginalArrivalTime: 09 Dec 2003 11:04:05.0059 (UTC)
FILETIME=[28F34130:01C3BE44]
> >
> > Hello Tim,
> >
> > Im having troubles here in Brazil about fetching clob in out param
from a stored procedure
> > using Oracle
> > and Perl DBI.
> >
> > Here a snip about my procedure:
> >
> > PROCEDURE GET_CUSTUMER_INFO
> > ( id in number default null
> > , vreturn out clob)
> >
>
>
> > At perl script:
> >
> > use DBI;
> > use DBD::Oracle qw(:ora_types);
> >
> > DBI->trace(2, 'dbi.log');
> >
> > $dbh = DBI->connect("connection string") || die $!;
> >
> > # local variables
> > $id = 1;
> > my $vreturn;
> >
> > $stmt = $dbh->prepare("BEGIN get_custumer_info(?, ?); END;");
> > $stmt->bind_param(1, $id);
> > $stmt->bind_param_inout(2, \$vreturn, {ora_type => ORA_CLOB});
> > $stmt->execute || die $!;
> > $stmt->finish();
> > $dbh->disconnect();
> > print "return = $vreturn\n";
> >
> > I already tryed get some info but without sucessful (mail list, other
people, etc).
> >
> > Help me with some idea, a question: returning clob in out param into
stored procedure is
> > supported
> > DBD::Oracle ?
> >
> > Thanks in advance
> >
> >
>
> --------------------------------------------------------------------------
------------------------
> > --
> >
> > MSN Messenger: converse com os seus amigos online. Instale gratis.
Clique aqui.
> >
> > ----- End forwarded message -----
>
> --
> ----------------------------------
> E-Mail: [EMAIL PROTECTED]
> Date: 09-Dec-2003
> Time: 14:12:10
> ----------------------------------
