Serializing Storable.pm objects via DBI to Oracle 10g
- From: chris.fuhrman@xxxxxxxxx (Chris Fuhrman)
- Date: Thu, 20 Oct 2005 12:09:14 -0400
Howdy,
I seem to have encountered an odd quirk somewhere when using DBI against
an Oracle 10g database. Here's the situation. I'm taking the following
object, serializing using Storable.pm, and inserting it into a CLOB
field in an Oracle 10g database running Solaris 9/sparc.
$VAR1 = 'obj';
$VAR2 = [
{
'security' => undef,
'data' => {
'tts_prop' => '0',
'tts_enable' => '1',
'tmpl_id' => '',
'channel' => '',
'_radio' => 'tts_enable dis_amd redir',
'_select' => 'mg_retries redir_retries redir_delay',
'prog_id' => '',
'slot_num' => '1',
'slot_text' => 'fklgjdflgkjdfl;kdjfglkjpwerwepmcvopwentweoinfoivnorinveribfdgynvlaiytlawygn cvgbtv iauefvgjdgfirugtv rilufn vughk vgru
gyfireuvgr'
},
'ses_id' => '3e350107dfee1b015a66efce8bf835869372c316',
'cls_id' => 'addprogram19'
}
];
Please make a note that slot_text is 128 bytes. This is very important.
Now, when I pull the "frozen" object from 10g it looks something like
this. Please note that this output was run through the strings(1)
before I cut-n-pasted it:
[
'addprogram19',
'2005/10/17 09:16:02',
'
tts_prop
tts_enable
tmpl_id
channel
tts_enable dis_amd redir
_radio
$mg_retries redir_retries redir_delay
_select
prog_id
slot_num
fklgjdflgkjdfl;kdjfglkjpwerwepmcvopwentweoinfoivnorinveribfdgynvlaiytlawygn cvgbtv iauefvgjdgfirugtv rilufn vughk vgrugyfireuvgr
slot_text',
'2005/10/17 09:16:02',
'3e350107dfee1b015a66efce8bf835869372c316',
undef,
'1'
],
When we attempt to unfreeze it using Storable, our perl program bombs
out spectacularly with an "Out of Memory" error.
Some interesting facts about this particular bug:
* This only happens when talking with Oracle 10g. This has worked
successfully with Oracle 8i running on both SPARC and intel
hardware.
* The application server that runs this code is using the Oracle
8i client software under Solaris 9 intel.
* Everything works fine under Oracle 10g when slot_text is LESS
THAN 128 bytes. Anything larger than that bombs out. I find
this suspect.
* Running our application code on a Solaris 8 sparc box using the
Oracle 8i client libraries produces the same error.
* This error is also reproducible on a Red Hat 9 Linux box running
on intel hardware.
* We have tried this with recent versions of DBI, DBD::Oracle
(1.15), and Storable.pm
I *suspect* the issue is in how Storable is putting the data into
Oracle, but I wanted to see if anyone has run into this error before.
Cheers!
--
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
- Follow-Ups:
- RE: Serializing Storable.pm objects via DBI to Oracle 10g
- From: Steve Baldwin
- RE: Serializing Storable.pm objects via DBI to Oracle 10g
- Prev by Date: Re: DBD::Oracle for Oracle instant client
- Next by Date: Is it a bug in DBD::SQLite?
- Previous by thread: bind_param not working with negative values ?
- Next by thread: RE: Serializing Storable.pm objects via DBI to Oracle 10g
- Index(es):
Relevant Pages
|
