title: How to solve operator does not exist error in PostgreSQL
body: <p>For table value BENMASTDTL_PAYEE_MOB_NUM am getting error like</p>
  <blockquote>
  <p>operator does not exist: bigint = text</p>
  </blockquote>
  <p>But I have declared its value in table as bigint.</p>
  <pre><code>ELSIF P_TRANSFER_TYPE = '7M' THEN
        
          EXECUTE 'SELECT BENMASTDTL_BEN_CODE FROM BENMASTDTL WHERE BENMASTDTL_ENTITY_CODE =$1 AND BENMASTDTL_CUSTOMER_CODE =$2 AND
                              BENMASTDTL_PAYEE_MOB_NUM =$3 AND BENMASTDTL_PAYEE_MMID=$4 AND BENMASTDTL_PAYEE_MMID_TYPE=$5 LIMIT 1'
            INTO STRICT W_BENMASTDTL_BEN_CODE
            USING P_ENTITY_CODE, P_CUST_CODE, P_BEN_MOB_NUM, P_BEN_MMID, P_BEN_MMID_TYPE;
  </code></pre>
  <p>Please help me to solve this error.</p>