Data Source URL in XML Query in reports

From: Jon Robertson <jrobertson_at_nitrosys.com>
Date: 7 Apr 2004 19:12:09 -0700
Message-ID: <b0146e64.0404071812.5a9d8d32_at_posting.google.com>

How can I make the URL for the Data Source of an XML query in Reports dynamic?

I'm using Reports Developer 9i. I have a stored procedure that selects the xml from a clob in the database, and I want to pass a parameter to the report with the primary key of the row that I want the report to be based on. I would like the URL to be something like:

http://servername/package_name.procedure?p_record_id=XXXX

I tried creating a user parameter and putting in this:

http://servername/package_name.procedure?p_record_id=:P_RECORD_ID

but this did not work.

Any ideas?

Thanks,
JR Received on Thu Apr 08 2004 - 04:12:09 CEST