Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q194799

↑ Back to the top


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.

↑ Back to the top


More information

  1. To insert images into an Oracle table, see the following article in the Microsoft Knowledge Base:
    185958� How To 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
       %>
    					
NOTE: Because you are changing the content type of this page, you can display only one image. In order to incorporate this into a page with text, you need to do a server side include of this .asp page to get the picture into another page.

↑ Back to the top


References

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

↑ Back to the top


Keywords: kbcode, kbhowto, kboracle, kbprovider, KB194799

↑ Back to the top

Article Info
Article ID : 194799
Revision : 5
Created on : 7/1/2004
Published on : 7/1/2004
Exists online : False
Views : 314