Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is difference between LONG RAW and BLOB

385610Mar 23 2004 — edited Mar 24 2004
I have a funny problem.

I am trying to save the byte code of compiled Java Class at the database.

I am reading the byte code of the class from the file correctly and can put and get it correctly from the database if I set the column type to LONG RAW.

Knowing that LONG RAW is an old type and may be going to be depreciated, I had tried to do same thing with BLOB column type but it is not working.

The byte array that I am sending to the database and the one I am getting back is different.

I ORACLE removing some values when inserting a BLOB.

I can not understand this, I had previously stored image data to the database without problem. It is byte data also. So why I can not insert byte data of compiled Java Class in a BLOB column without ORACLE not changing anything in the byte array.

Thx for the answers.

Memos
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2004
Added on Mar 23 2004
7 comments
1,225 views