RE: Oracle and BLOBs

I don't know if this helps, but if you want to insert into a BLOB column,
you can by simply specifying the ora_type attribute. For example ...

use DBD::Oracle qw(:ora_types);
:
my $sth = $dbh->prepare(q(
insert into some_table (blob_col) values (:blob_data)
));
$sth->bind_param(':blob_data', $some_buff,
{ ora_type=>ORA_BLOB, ora_field=>'blob_col' });
$sth->execute;

Steve

-----Original Message-----
From: Ron Savage [mailto:ron@xxxxxxxxxxxxx]
Sent: Thursday, 24 November 2005 11:37 AM
To: List - DBI users
Subject: RE: Oracle and BLOBs

On Wed, 23 Nov 2005 19:28:43 -0500, Ted Behling wrote:

Hi Ted

> If I remember properly, I think I saw that error when setting up
> Apache::Session::Oracle. I have my A_SESSION column set up as type
> LONG. I'm running 9iR2. Hope that helps.

That worked! Ah, well. So much for trying to do the right thing...

$many x $thanx;

--
Ron Savage
ron@xxxxxxxxxxxxx
http://savage.net.au/index.html




.