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,

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

Original text of this message