title: Error "ORA-00932: inconsistent datatypes: expected - got BLOB" in Join Statement
body: <p>I have problem executing below stored procedure.<br/>
  I am getting error of <code>ORA-00932: inconsistent datatypes: expected - got BLOB</code> when I add
  <code>FM.FAXFILE_BLOB</code> column in below stored procedure.<code>FAXFILE_BLOB</code> is a blob field.<br/><br/>If I remove this field everything works fine.I don't know why this is happening.<br />Please help....<br/><br/></p>
  
  <pre><code>        CREATE OR REPLACE Procedure HCADMIN.Proc_GetFaxDetailsByDate
           ( 
             FromDate varchar2 default null,
             ToDate varchar2 default null,
             FaxNo varchar2 default null,
             ClaimNo varchar2 default null,
              NspCode varchar2 default null,
             PolicyNo varchar2 default null,
             HEGICNo varchar2 default null,
             cur_faxdetails OUT SYS_REFCURSOR
             )
          IS
         BEGIN
        OPEN cur_faxdetails For
  
        Select distinct
         FM.RECORDNO_NUM,
         FM.CLAIMNO_VAR,
         FM.FAXNO_VAR,
         FM.FAXSTATUS_VAR,
         FM.FAXTYPE_VAR,
         FM.USERNAME_VAR,
         FM.HEGIC_NO_VAR, 
         FM.RESEND_NO_NUM,
         FM.RESNDCOUNT_NUM,
         TO_date(FM.TIMESTAMP_DTE,'dd/MM/yyyy') as "TIMESTAMP_DTE",
         FR.RECIPIENTFAXNO_VAR,
         FM.FAXFILE_BLOB
  
         From TPA_FAXMASTER FM Left  join TPA_FAXRECIPIENT FR on                                      FM.RECORDNO_NUM=FR.RECORDNO_NUM 
   WHERE 
        NVL(FM.FAXNO_VAR,'0')=NVL(FaxNo,NVL(FM.FAXNO_VAR,'0')) And
        NVL(FR.RECIPIENTFAXNO_VAR,'0')=NVL(FaxNo,NVL(FR.RECIPIENTFAXNO_VAR,'0')) And          
        NVL(FM.CLAIMNO_VAR,'0')=NVL(ClaimNo,NVL(FM.CLAIMNO_VAR,'0')) And  
        NVL(FM.NSPID_VAR,'0')=NVL(NspCode,NVL(FM.NSPID_VAR,'0')) And
        NVL(FM.POLICYNO_VAR,'0')=NVL(PolicyNo,NVL(FM.POLICYNO_VAR,'0')) And  
        NVL(FM.HEGIC_NO_VAR,'0')=NVL(HEGICNo,NVL(FM.HEGIC_NO_VAR,'0')) And    
        (NVL(TO_date(FM.TIMESTAMP_DTE,'dd/MM/yyy'),To_Date('09/09/9999','dd/MM/yyyy')) 
        BETWEEN NVL (TO_date(FromDate,'dd/MM/yyyy'), NVL(TO_date(FM.TIMESTAMP_DTE,'dd/MM/yyy'),To_Date('09/09/9999','dd/MM/yyyy')))
        AND  NVL (TO_date(ToDate,'dd/MM/yyyy'), NVL(TO_date(FM.TIMESTAMP_DTE,'dd/MM/yyy'),To_Date('09/09/9999','dd/MM/yyyy'))));
  EXCEPTION
   WHEN NO_DATA_FOUND THEN
     Null;
   WHEN OTHERS THEN
     -- Consider logging the error and then re-raise
     RAISE;
   END;
   /
  </code></pre>