Oracle Forms

Hi all,

I have a problem,

My application was running smoothly using database 8i and application server 9i and forms developer 6i

I have only switch from database 8i to 9i.

In 8i I have a blob column in the employees table to store their images. and my form showing the images without any Error.
But when I have switch the databse, my form doesn't show any image.

Smeone told me to change the blob datatype to long raw. because 9i display longraw data instead of blob.

I have tried it by creating the new column with long raw datatype and upload a new image in this column. (I have upload the image directly to the database using Plsql Developer). and my form shows the picture using this colun data (Long Raw).

Now I want to convert my Existing column data with blob data type to long raw data.

Is there any way to convert Blob data to long raw data.

Regards,

Raza.