Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bind Variables and Shared Component Report Query

kgambleJan 19 2011 — edited Jan 22 2011
I have a query in a region report which I have replicated to a shared component report query.
Both queries reference page items as bind variables in the where clause.
The report region on screen shows the correct results but the report query shows "no data". This is the case when running "Test Query" and "Download XML data" from the shared component report query definition. If I hardcode the variable names I get rows returned, If I use bind variables - and specify the values for these variables I get no data. THe XML file contains the tags for each bind variable I have specified but has no data between the tags. I have Ticked the box to include application and session state but it appears that the bind variables are not being used.

When I use my report query in the application (URL tied to a button) I get the same problem, the binds are not being passed to the report query.

Can someone please clarify if this is a bug or not? And if not, how can I get it to work.

I am using Apex 4.0.2

Thanks
Kathryn
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2011
Added on Jan 19 2011
12 comments
3,133 views