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