<!-- File name: ord_image_demo_04.xcp -->
<xcp:page>
   <xcp:import>
      import java.sql.*;
      import java.io.*;
      import oracle.jdbc.driver.*;
      import oracle.sql.*;
      import oracle.ord.im.*;
   </xcp:import>
   
   <xcp:code>
      <![CDATA[
         Statement s = this.connection.createStatement();
         OracleResultSet rs = (OracleResultSet)s.executeQuery("SELECT  S.image_name , S.image_s1 blb1, S.image_s2 blb2 FROM myImg S WHERE S.image_id = 1");
         ResultSetMetaData rsmd = rs.getMetaData();
         
         while(rs.next())
         {
            OrdImage oi = (OrdImage)rs.getCustomDatum(3, OrdImage.getFactory( ));
            
            oracle.sql.BLOB blb = oi.getContent();
            
            this.response.setContentType("image/jpeg");
            
            OutputStream os = this.response.getOutputStream();
            Utils.readStream(blb.getBinaryStream(), os);
            break;
         }
      ]]>

   </xcp:code>           
</xcp:page>