ORA-01722 invalid number error & subquery

SELECT COUNT(T4.bbb_no) , T1.t1_code
FROM table2 T2, table1 T1, Table4 T4, table5 T5, table6 T6
WHERE T4.aaa_no != 0 AND T4.bbb_no = T2.bbb_no AND T2.aaa_no = T2.ccc_no
AND T2.aaa_no = T1.aaa_no
AND T4.aaa_no = T5.aaa_no AND T5.aaa_name = 'A003'
AND TO_CHAR(TO_DATE(T4.aaa_date,'YYYYMMDD') + T5.aaa_days -1,'YYYYMM')
= '200304'
AND T4.ddd_code = 91 AND T4.eee_code = 10
AND T1.aaa_code in (select aaa_code from AAA_BBB where BBB_code = 1)
AND T4.ddd_code = T6.ddd_code(+) AND T4.eee_code = T6.eee_code(+)
AND T4.aaa_no = T6.aaa_no(+) AND T4.aaa_date = T6.aaa_date(+)
AND TO_CHAR(TO_DATE(T4.aaa_date,'YYYYMMDD') + T5.aaa_days -1,'YYYYMMDD') <
DECODE(T6.bbb_date, NULL, '99999999', T6.bbb_date)
GROUP BY T1.t1_code
Error occur in line 4 at the position of T1.aaa_no Its data type is char(2). But only stored numeric characters. It's sure.

if I remove line 9 or
if I replace subquery with its equivalent expression list . Is there any relationship?

Received on Wed Apr 23 2003 - 05:19:11 CEST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]