Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Failed to retrieve data from the database ORA-24374 define not done before fetch or execute and fetch

Hi All,

I have a report request for Crystal reports 2004 and get the error Failed to retrieve data from the database ORA-24374 define not done before fetch or execute and fetch

I am trying to have three parameters like the below. when I select the manual entry it should allow me to input any dates and when I select option 2 in the date-selector it should select only yesterdays date and in Option 3 it should select the last week range

I have tried the below sql query but it works when I hard code the values in the oracle sql developer so the syntax is right,but I get the below error message

Failed to retrieve data from the database ORA-24374 define not done before fetch or execute and fetch

and (1= {?DATE_SELECTOR}

   and trunc(da.create_date_time) between {?Create Date Start} and {?Create Date End})

   OR

  ( 2={?DATE_SELECTOR}

  and trunc(da.create_date_time) = trunc(sysdate-1,'DD'))

  OR

  (3={?DATE_SELECTOR}

   and trunc(da.create_date_time) between trunc(sysdate-7,'DD') and trunc(sysdate-1,'DD'))

Can anyone help,Thanks in advance

Former Member
Not what you were looking for? View more on this topic or Ask a question