Oracle Error : not a valid month
Posted: Wed Sep 07, 2005 5:18 am
Hallo all,
I tried copy the query in run in SQL Toad and the query works fine.
Any idea why this is happening.
oraS_STDALT_IDN,0: Oracle call failed: sqlcode = -1,843
Message: ORA-01843: not a valid month
In Oracle the data type for ZCOMPLDT is NUMBER and data type in DataStage is Integer. This job has been running in production every month. Until this month it aborted with the above error.oraS_STDALT_IDN,0: Array Fetch failed for: SELECT ZCOMPLDT,ZRCVDT,ZALSTAT,"DESCRP", ((to_date(ZCOMPLDT, 'YYYYMMDD') - to_date(ZRCVDT, 'YYYYMMDD')) + 1) as AMOUNT FROM S_STDALT_IDN WHERE
substr(ZCOMPLDT, 1, 4)||'0'||substr(ZCOMPLDT, 5, 2) = substr(200500831,1,7) AND ZALSTAT='F'
and period=200500831
I tried copy the query in run in SQL Toad and the query works fine.
Any idea why this is happening.