sir i have problem with blob datatype in oracle <BR>i have to insert/retrieve the blob data of ORACLE DATABASE into the browser using ASP <BR><BR>I AM GIVE THE CODE FROM WHERE I AM GETTING THE ERROR <BR><BR>IF POSIBLE CORRECT IT OR ELSE PLEASE GIVE THE CODE FOR THE ABOVE<BR>PROBLEM AS EARLY AS POSIBLE BECAUSE BY BOSS IS FORCING ME TO DO IT TODAY IT SELF<BR><BR>WAITING FOR YOUR REPLY EARGLY...<BR>THANKS IN ADVANCE<BR><BR><BR><BR><BR><BR>&#060;%<BR>Set rs = server.CreateObject("ADODB.Recordset")<BR> <BR> rs.Open "Select * from myimage where filename=&#039;ganesh2.jpg&#039;" ,cn<BR> <BR> Response.ContentType ="image/jpeg"<BR> <BR>Response.AddHeader "Content-Disposition", "attachment;filename=&#039;" & RS("filename") & "&#039;"<BR> <BR> Response.BinaryWrite rs.Fields("imagedata").Value <BR><BR> Response.End <BR><BR>%&#062;<BR><BR><BR>THE ABOVE CODE IN ORACLE IS GIVING <BR><BR>Error Type:<BR>Response object, ASP 0106 (0x80020005)<BR>An unhandled data type was encountered.<BR><BR><BR>TABLE FOR ABOVE ::MYIMAGE<BR><BR><BR>Name Null? Type<BR>----------------------------------------------------- -------- ------------------<BR>FILENAME VARCHAR2(50)<BR>IMAGEDATA BLOB<BR>