ORA-06502
From: bob123 <bob123_at_gmail.com>
Date: Wed, 4 Feb 2009 21:32:59 +0100
Message-ID: <4989fb7c$0$5237$426a74cc_at_news.free.fr>
Hi,
'01/01/2008'
Received on Wed Feb 04 2009 - 14:32:59 CST
Date: Wed, 4 Feb 2009 21:32:59 +0100
Message-ID: <4989fb7c$0$5237$426a74cc_at_news.free.fr>
Hi,
I have the follwing error with the query below:
OK for 01/01/2008 and 15/07/2008
OK for 01/08/2008 and 30/09/2008
ORA-06502 with other values
Thanks for your help (9.2.0.6)
SELECT V$CASE_MASTER.CASE_NUM,
V$CASE_DOSE_REGIMENS.START_DATETIME, DBMS_LOB.SUBSTR(V$CASE_NARRATIVE.NARRATIVE,DBMS_LOB.getlength(V$CASE_NARRATIVE.NARRATIVE),1) FROM V$CASE_MASTER, V$CASE_DOSE_REGIMENS, V$CASE_PRODUCT, V$CASE_NARRATIVE, V$CASE_STUDY WHERE V$CASE_PRODUCT.CASE_ID (+) = V$CASE_MASTER.CASE_ID AND V$CASE_DOSE_REGIMENS.CASE_ID (+) = V$CASE_PRODUCT.CASE_ID AND V$CASE_DOSE_REGIMENS.SEQ_NUM (+) = V$CASE_PRODUCT.SEQ_NUM AND V$CASE_STUDY.CASE_ID (+) = V$CASE_MASTER.CASE_ID AND V$CASE_STUDY.STUDY_NUM = 'CL3-16257-063' AND V$CASE_MASTER.CASE_ID = V$CASE_NARRATIVE.CASE_ID (+)AND TO_DATE (TO_CHAR(V$CASE_MASTER.CREATE_TIME,'dd-mon-yyyy')) >=
'01/01/2008'
AND TO_DATE (TO_CHAR(V$CASE_MASTER.CREATE_TIME,'dd-mon-yyyy')) <=
'30/09/2008'
ORDER BY V$CASE_MASTER.CASE_NUM,
V$CASE_DOSE_REGIMENS.START_DATETIME;
Received on Wed Feb 04 2009 - 14:32:59 CST