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:[EMAIL PROTECTED] 
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
[EMAIL PROTECTED]
http://savage.net.au/index.html



Reply via email to