I´m using ASP 3.0 with II 5.0 and my data base is 9i r2.

I´m moving all my data (ms access) to our ORACLE, but I have problems with the file objects (jpg,gif,doc,pdf,txt,etc) store in my access.

I create a table using long raw, bfile y blob, and using my old rutine to upload to my access I can upload to my oracle, but when I try to read and display the content of the column, I have many errors.

If some body can help me, I need to see any rutine for upload in ASP and any rutine for display using asp too.

for upload
rsDoc9.Fields("Documento").AppendChunk fileData
rsDoc9.Fields("ContentType").Value = contentType


For display
Set RS = OraDatabase.DbCreateDynaset( sSQL, cint(0))
Response.ContentType = rs.Fields("ContentType").Value
Response.BinaryWrite rs.Fields("Documento").Value


Thank for your help.
My e-mail is [email protected]

Ing. Berlington Barnett Martínez, Lic.
Developer, IT Department
Phone: (506)257-0145 Ext. 201
www.fomuvel.com