How To Retrieve RAW/LONG RAW Data from Oracle for ASP Page

      <%@ LANGUAGE="VBSCRIPT" %>

      <%
      'Clear existing HTTP header information.
      Response.Expires = 0
      Response.Buffer = TRUE
      Response.Clear

      'Set the HTTP header to an image type, if you want to display
      'a jpg you need to use the "image/jpeg" content type.
      Response.ContentType = "image/gif"

      Dim strTemp

      Set oConn = Server.CreateObject("ADODB.Connection")

     'You need to change this line to reflect your DSN, UID
     'and PWD.
      oConn.Open "DSN=Ovteam;UID=userid;PWD=password;"

     'Change this line to use your table that contains a raw or
     'long raw field.  In this case, ID is the primary key of the
     'IMAGE table and IMG is the RAW or LONG RAW data column.
      sSQL = "Select ID, IMG from IMAGE where ID = 1"

      Set oRS = Server.CreateObject("ADODB.Recordset")
      oRS.Source = sSQL
      oRS.ActiveConnection = oConn

     'The cursor type does not seem to matter.  A keyset cursor was used
     'with success for this article; however, you will not be able to
     'scroll with it because the content type of this page is set for
     '"image/gif".

      oRS.Open

      strtemp = oRS("IMG")
      Response.BinaryWrite(strTemp)
      Response.End

      oRS.Close
      Set oRS = nothing
      oConn.Close
      Set oConn = nothing
   %>