Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

? Running an Oracle Report from the Web Using PL/SQL Web Page

Status
Not open for further replies.

mgmonto

MIS
May 13, 2004
4
US
I have a PL/SQL Web Page, very simple, and I'm trying to run a report on the click of a button, within the page.

The PL/SQL Server Web Page Procedure is as follows:
create or replace procedure my_first_psp as
begin
snl_iris_common.h_open('My First PSP'--common code for page
htp.header(1,'We''re going to try to run a report from the Web');
htp.print('<td valign=bottom>' || '<input type=button value="Display Report"onclick="snl_iris_common.h_close;--common code to close web page. end my_first_psp;

I'm using the 9i reports builder on my local machine and the database is on another machine, both windows xp, I believe. I know that my machine is xp and am not sure of the other. I do know that both are definitely windows os.

I DO NOT have the Oracle 9iAS set up at this time, but our ultimate goal is to have the reports services running off of the 9iAS and run the reports from the web, using PL/SQL server pages, and the 9iAS reports services. At this point however, I'm just trying to do a proof of concept and mimic the 9iAS, but still run reports from the web.

I also do indeed have the reports builder OC4J Instance running when trying to run the report from the web. I have also successfully created a DAD, as shown by the PL/SQL web page successfully launching within the browser.

I've tried several things, but they all have failed:
Using the rwrun where the url is in the above procedure.

Using the rwcgi where the url is in the above procedure.

Using the rwservlet where the url is in the above procedure.

Using the plus sign + instead of the & for the parameters.

Any guidance/assistance is much appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top