in reply to Storing/Retrieving Blobs from Oracle

I saw your post when looking for some answers on getting blobs out of an oracle database.

I had exactly the same error message you are getting when i was trying to store a blob. What i am doing is using freeze/thaw to create a persistant object. when 'freeze'd the object and went to stuff it into an oracle blob i got the same error message.

to fix it i just unpacked the data, and parsed it to a database routine as a bindvar.

unpack("H*",freeze($self))

HTH
.R

Come to think of it, if i'm unpacking the the var to Hex, i could prolly store it in a varchar.. right?