RE: Serializing Storable.pm objects via DBI to Oracle 10g

Not sure this would work but I can give it a shot.

Reason I say this is that I tried to take the "frozen" storable object
and then MIME::Base64 encode it before putting it in the data-base.
Still got the same error so I'm now starting to suspect it's something
going on between Storable.pm and Oracle 10g.

On Fri, 2005-10-21 at 06:38 +1000, Steve Baldwin wrote:
> I haven't tried this on 10g, but what if you gzip your frozen object and
> store it in a BLOB rather than a CLOB. Here's some code I use that works
> fine in 9.2.0.6 ...
>
> my $config_data = Compress::Zlib::memGzip(freeze($config));
> my $table_data = Compress::Zlib::memGzip(freeze($Table));
> my $sth_info_ins = $PLX->dbh->prepare(
> "INSERT INTO $info_table (config_data, table_data)"
> . " VALUES (:cdata, :tdata)"
> );
> $sth_info_ins->bind_param(
> ':cdata', $config_data,
> {
> ora_type => ORA_BLOB,
> ora_field => 'config_data'
> });
> $sth_info_ins->bind_param(
> ':tdata', $table_data,
> {
> ora_type => ORA_BLOB,
> ora_field => 'table_data'
> });
> $sth_info_ins->execute;
>
> Steve
>

--
Chris Fuhrman | Twenty First Century Communications
chris.fuhrman@xxxxxxxxx | Senior Software Engineer
(W) 614-442-1215 x271 |
(F) 614-442-5662 | PGP/GPG Public Key Available on Request

Attachment:signature.asc
Description: This is a digitally signed message part