----- Forwarded message from Raj Chandran <[EMAIL PROTECTED]> -----
Delivered-To: [EMAIL PROTECTED]
X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] to mail through
132.236.56.21)
Subject: Trouble with returning BLOB
From: Raj Chandran <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: 12 May 2004 12:03:10 -0400
X-PMX-Version: 4.5.0.92886, Antispam-Core: 4.0.4.93542, Antispam-Data: 2004.5.11.100443
Hi Tim,
I have used your DBD::Oracle to write LOB in chunks and I wanted to
streamline my code a little more by combining 'insert EMPTY_BLOB'
statement and 'get locator' select query.
Please see the code below.
($id, $loc) = (1, undef);
$stmt = "INSERT INTO $TABLE VALUES (?, EMPTY_BLOB()) returning file into
?";
$sth = $dbh->prepare($stmt) or die $dbh->errstr;
$sth->bind_param(1, $id) or die $dbh->errstr;
$sth->bind_param_inout(2, \$loc, 1000, {ora_type => ORA_BLOB}) or die
$dbh->errstr;
$sth->execute or die $dbh->errstr;
print "After 2nd statement loc : $loc\n";
I am getting a Segementation Fault when I run this code.
Why am I getting this error ?
Many Thanks,
Raj
----- End forwarded message -----
