I am using Interactive Reports in Apex and for some reason the same query
sometimes returns with data and sometimes returns with 'No Data Found'.
There are no variables. It is a direct database query.
In sql it always returns with data.
This is an application made up of about 25 pages with an interactive report on each page.
Does anyone know of any reason or setting that would cause this issue?
Apex version is: 3.1.0.00.32.
Database version is: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options.
A sample query is:
select b.name benchmark, to_char(a.benchmarkid) benchmarkid
from advisory_benchmark_dtl a, active_benchmarks b
where a.secid=b.ticker and a.benchmarkid in (
select benchmarkid from s_psectors
active_benchmarks is a simple view, advisory_benchmark_dtl and s_psectors
I found the answer to my question -
Apex does not like date = '30-JUN-10'.
Although in sql it works fine,
Apex expects it as '30-JUN-2010'.
Thank you to all who tried to help.
Edited by: user12004071 on Sep 2, 2010 2:55 AM