This discussion is archived
5 Replies Latest reply: Dec 5, 2012 2:32 AM by Paul Horth RSS

ORA-01481: invalid number format model

bala1 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points