title: Inserting Image Into BLOB Oracle 10g
body: <p>I am trying to insert an image into an BLOB field in a signatures which i will then select from the table and render on a report. I cannot seem to figure how to get the image into the table. I did an insert however when i render only the path to the image was shown on the report and not the image itself. </p>
  
  <p><strong>Table</strong></p>
  
  <pre><code>CREATE TABLE esignatures (
    office   NUMBER(6,0)  NOT NULL,
    username VARCHAR2(10) NOT NULL,
    iblob    BLOB         NOT NULL
  )
  </code></pre>
  
  <p><strong>INSERT Statement (SQL)</strong></p>
  
  <pre><code>INSERT INTO esignatures  
  VALUES (100, 'BOB', utl_raw.cast_to_raw('C:\pictures\image1.png'));
  </code></pre>
  
  <p>I know for sure i am inserting the String location in the form of a HEX value how can i get the image HEX value in the table so when i render i will see the image being displayed. </p>