Oracle 8 and Blob Data Type

When I try to insert data into a table containing blob columns, the blob
field does not contain any value. It seems that the BDE inserts empty_blob()
in the column. The same thing happens while updating a record. If I use long
raw instead of blob it works. But the problem with long column is that there
can be only one of it in a table. Hence I
need to use blob.

I am using Delphi 4 with update pack 2 and BDE 5.01. Is there any
solution/work around for this problem?

Mohan Shenoy
Tel: 91-22-6249025