5 Replies Latest reply: Dec 5, 2012 4:35 AM by Solomon Yakobson RSS

    ORA-01481: invalid number format model

    bala1
      Hi

      whn I am trying to execute this query, i am getting this error ora-01481
      SELECT A.MSISDN_NSK as IDENTIFICATION_CODE_V ,RECH1_CR_AMT as EVENT_QUANTITY_N,DATE_KEY as EVENT_DATE_D, :1 AS CAMPAIGN_CODE_V,
      B.PAYMENT_OPTION_CD
      FROM BIB_CDR.FCT_LCM_RECHARGE
      A JOIN BIB.DIM_PAYMENT_OPTION B ON A.PAYMENT_OPTION_KEY=B.PAYMENT_OPTION_KEY WHERE to_char(DATE_KEY, 'YYYYMMDD') = to_date(:2,'YYYYMMDD') AND
      RECH1_CR_AMT > 500 AND RECH1_CR_AMT <= 50000 AND A.MSISDN_NSK like :3||'%' order by 1
      date_key is number datatype.