1 2 Previous Next 21 Replies Latest reply: Dec 29, 2009 4:20 AM by Hoek RSS

    date issue.. "expected DATE got NUMBER"

    Naren
      hi all, i have a date column retrived from source(oracle) and trying to dump to target(oracle)

      Query
      ------------

      SELECT DISTINCT
      -1 AS ESKALATION_ID
      ,COALESCE(SRC.SRC_ID,-1) AS DEALER_ID
      ,COALESCE(SRC.SRC_ID,-1) AS CUSTOMER_ID
      ,*coalesce(to_date(TO_CHAR(SR_TL.SR_RESOLVED_DT,'mm/dd/yyyy'),'mm/dd/yyyy'),-1) AS SPRT_RSL_DATE_VALUE*
      from
      FROM IUOWNER.IU_SR SR
      LEFT OUTER JOIN IUOWNER.IU_SR_SRVC SR_SRVC ON SR.SR_ID=SR_SRVC.SR_ID
      LEFT OUTER JOIN IUOWNER.IU_SR_RQSTR SR_RQSTR ON SR.SR_ID=SR_RQSTR.SR_ID
      LEFT OUTER JOIN IUOWNER.IU_SR_PRD SR_PRD ON SR.SR_ID = SR_PRD.SR_ID
      LEFT OUTER JOIN SHOWNER.WC_PRD_CLS PRD_CLS ON PRD_CLS.PRD_CLS_CD = SR_PRD.PRD_CLS_CD
      LEFT OUTER JOIN SHOWNER.WC_SRC SRC ON SR_RQSTR.SRC_CD = SRC.SRC_CD
      LEFT OUTER JOIN IUOWNER.IU_SR_SRVC_PART SRVC_PART ON SRVC_PART.SR_ID=SR.SR_ID
      LEFT OUTER JOIN SHOWNER.WC_PART PART ON PART.PART_CLS_ID=SRVC_PART.PART_CLS_ID
      LEFT OUTER JOIN SHOWNER.WC_PART_CLS PART_CLS ON PART.PART_CLS_ID = PART_CLS.PART_CLS_ID
      LEFT OUTER JOIN IPOWNER.IP_ORDR_PART ORDER_PART ON PART.PART_CLS_ID=ORDER_PART.PART_CLS_ID
      LEFT OUTER JOIN SHOWNER.WC_PRD PRD ON PRD.PRD_CLS_ID = PRD_CLS.PRD_CLS_ID
      LEFT OUTER JOIN IPOWNER.IP_ORDR_SHIP ORDR_SHIP ON ORDR_SHIP.ORDR_ID = ORDER_PART.ORDR_ID
      LEFT OUTER JOIN IPOWNER.IP_ORDR ORDR ON ORDR.ORDR_ID = ORDER_PART.ORDR_ID
      LEFT OUTER JOIN IUOWNER.IU_SR_ORDR_TRK ORDR_TRK ON ORDR_TRK.SR_ID = SR.SR_ID
      LEFT OUTER JOIN SHOWNER.WC_SRC_PYMT_TRN SR_PYMT ON SR_PYMT.ENTITY_ID = SR.SR_ID
      LEFT OUTER JOIN SHOWNER.WC_SRC_PYMT PYMT ON PYMT.PYMT_ID=SR_PYMT.PYMT_ID
      LEFT OUTER JOIN IUOWNER.IU_SR_TL SR_TL ON SR.SR_ID=SR_TL.SR_ID


      i am getting this error message ............ " ORA-00932: inconsistent datatypes: expected DATE got NUMBER"

      how can i handle this.. plz let me know

      Regards
      Narendar Vishwanatham
        1 2 Previous Next