Report 2A : Bind Variable does not exist

nuraniuscc

Hi Mike,

This is the Query and It is Correct. But no rows retrieved.

select DATACENTER, CYCLE_RUN_MONTH || '/' || CYCLE_CODE || '/' || CYCLE_RUN_YEAR as CYCLE, TO_DATE(UPDATEDATE, 'DD-MON-YY') - TO_DATE(CREATEDATE, 'DD-MON-YY'), CYCLE_CODE from TBLRMSOLUTIONS A, TBLRMREJECTLIST B where A.ERRORNO = B.EXPERTKEY and DATACENTER in ('M01') and CYCLE_RUN_MONTH in (08) and CYCLE_CODE in (02) and CYCLE_RUN_YEAR in (2008) group by DATACENTER, CYCLE_RUN_MONTH || '/' || CYCLE_CODE || '/' || CYCLE_RUN_YEAR,TO_DATE(UPDATEDATE, 'DD-MON-YY') - TO_DATE(CREATEDATE, 'DD-MON-YY'), CYCLE_CODE order by DATACENTER, CYCLE_RUN_MONTH || '/' || CYCLE_CODE || '/' || CYCLE_RUN_YEAR

I, infact deleted all the BIND variables and pointed it back to the Dataset.

My only question here is,

CYCLE is concatenated across 3 fields and CYCLE_CODE is being used in the build of the AND clause in the script. Since it was complaining I added CYCLE_CODE as one of the columns to SELECT, eventhough I don't need that.

Table (id = 22):
+ An exception occurred during processing. Please see the following message for details:
Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-01006: bind variable does not exist


Your Input Please.

Thanks
Nurani Sivakumar

nuraniuscc

Hi Mike,

I am having the same issue in 2 reports. Your quick response is appreciated.

Thanks
Nurani Sivakumar