hello sir<BR><BR>i have a problem with blob in (oracle database) <BR>how i insert/retrive the image from blob datatype in oracle<BR><BR>i am also giving the code where i am getting the error.<BR><BR>please help me from this problem.as early as posible<BR>advance thanks<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><BR>IMAGEDATA BLOB<BR>