Inconsistent Data types Error
G.YJan 21 2013 — edited Jan 21 2013Dear All
please help about the following error:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
00932. 00000 - "inconsistent datatypes: expected %s got %s"
*Cause:
*Action:
Error at Line: 19 Column: 18
SELECT A.EMP_CODE,
TRUNC(A.DT, 'MON') + LEVEL - 1 REST_DATE,
TO_CHAR (TRUNC (A.DT, 'MON') + LEVEL - 1, 'DAY') REST_DAY
FROM
(
SELECT A.EMP_CODE, A.RDY, D.DT
FROM
(SELECT A.EMP_CODE, TO_CHAR(A.RDAY,'DAY') RDY
FROM HCM.emp_info_rest A, HCM.personnel B
WHERE (A.EMP_CODE = B.EMP_CODE)
AND (B.EMP_TYPE = '04' AND B.EMP_STATUS IN ('01','03'))
AND (B.DEPT_CODE = '06') AND A.EMP_CODE = 610
)A,
(
SELECT TO_CHAR(TO_DATE('15-JAN-2013','DD-MON-YYYY'))AS DT FROM DUAL
)D
)A
WHERE TO_CHAR (TRUNC (A.DT, 'MON') + LEVEL - 1, 'DAY') =(RDY)
CONNECT BY LEVEL <= LASTDAY (A.DT) - TRUNC (A.DT, 'MON') + 1;_*----line no 19
thanks in advance.