Re: doubt in binmode

Most likely you didn't tell Oracle that you want the data stored as a binary blob. Have you verified that the data was stored correctly in the database? Using binmode never hurts, so you should always use it.

I recommend you ask your Oracle DBA about your database and how to talk to it and how to verify what data gets stored in the database.

Comment on Re: doubt in binmode

Replies are listed 'Best First'.
Re^2: doubt in binmode by mdsaleemj (Initiate) on Jun 29, 2010 at 04:52 UTC
but i stored the compressed data(lzop) in database as CLOB.	[reply]
Re^3: doubt in binmode by afoken (Chancellor) on Jun 30, 2010 at 04:18 UTC
Simple: Don't store binary data in a character-oriented storage. CLOB is a Character Large Object. You want a BLOB, a Binary Large Object. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]
Re^4: doubt in binmode by mdsaleemj (Initiate) on Jun 30, 2010 at 13:46 UTC
Thnx... I changed the table column as BLOB...Now i am able to decompress...Thank u Monks.....	[reply]