Hi All,

i created a oracle collector. i have a query like below;

select
MY_DATE,
TO_CHAR('MY_DATE','YYYY/MM/DD HH24:MI:SS','nls_date_language=AMERICAN')
MDATE

WHERE
MY_DATE >= TO_DATE('%s','YYYY/MM/DD
HH24:MI:SS','nls_date_language=AMERICAN') and rownum <= %d

ORDER BY
MY_DATE

and i am returning 'return input.RXMap.col_MDATE;'

When i run the collector it is giving to me ORA-01840 input value not
long enough for date format so i want to debug and see the value of %s.

When run the collector debug mod always saying to me NODATA. Anybody
know how can debug and how can see %s value ??


--
ibasaran
------------------------------------------------------------------------
ibasaran's Profile: https://forums.netiq.com/member.php?userid=2826
View this thread: https://forums.netiq.com/showthread.php?t=46067