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