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.
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.