RE: Oracle and BLOBs

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.

Ted Behling

-----Original Message-----
From: Ron Savage [mailto:ron@xxxxxxxxxxxxx]
Sent: Wednesday, November 23, 2005 7:24 PM
To: List - DBI users
Subject: Q: Oracle and BLOBs

Hi Folks

I've written CGI::Session::Driver::oracle.pm using a_session of type
BLOB, and get the Oracle error ORA-01465: invalid hex number when the
content to be inserted in that field is output from Data::Dumper.

I've read Oracle docs and dozens of questions on AskTom, but nothing
says that text put into a BLOB field must be hex-encoded.

Any ideas?

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



.