title: Store Images in CLOB column -- Oracle 11G
body: <p>How to store images in CLOBs?
  Already have used BLOBs to store images and its working like a charm. But now, need to change the flow to store in CLOB.
  Tried with something like :</p>
  
  <pre><code>   dbms_lob.LOADCLOBFROMFILE(L_CLOB,L_File_Ptr,DBMS_LOB.LOBMAXSIZE,
                                dst_offset,src_offset,dbms_lob.default_csid,
                                lang_ctx,warning);   
  </code></pre>
  
  <p>After this, L_CLOB will always have some junk value (���JFIF in all cases) and i am not able to read from this.</p>
  
  <p>Read in post some where that base64 encoding has to be done, but is it related to only storing large Strings in CLOB or can it be applied to images well?</p>
  
  <p>Please help me out on this.</p>