That might not be relevant here but the lack of an error message
doesn't help anyone. Confirmation that the examples in the docs
work would be handy.
Tim.
On Tue, Dec 09, 2003 at 02:14:59PM -0600, [EMAIL PROTECTED] wrote:
>
>
> 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
> ----------------------------------
