HOWTO: Retrieve RAW/LONG RAW Data from Oracle for ASP Page

• Microsoft ODBC for Oracle (Build 2.573.2927), version 2.5
• ActiveX Data Objects (ADO), version 2.0
• Active Server Pages

SUMMARY

This article explains how to insert and retrieve RAW or LONG RAW data from an Oracle database for use in an Active Server Pages (ASP) page.

MORE INFORMATION

1. To insert images into an Oracle table, lease see the following article in the Microsoft Knowledge Base:

   Q185958 HOWTO: Use ADO GetChunk/AppendChunk with Oracle for BLOB Data

   NOTE: We do not recommend using Microsoft Access to insert images into Oracle. Microsoft Access adds an OLE wrapper around the object that prevents the object from being extracted and interpreted correctly by .asp.



2. To query and display the image, use the following code:

   
         <%@ 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
      %> 

REFERENCES

For additional information, please see the following article in the Microsoft Knowledge Base: Q192743 HOWTO: Use ADO GetChunk/AppendChunk with Oracle for TEXT Data

Additional query words:

Keywords : kbADO kbASP kbOracle kbGrpASP
Version : WINDOWS:2.0,2.5; winnt:
Platform : WINDOWS winnt
Issue type : kbhowto