This content has been marked as final. Show 9 replies
that runs reports via: c:\orant\bin\rwrun60.exe rep_name.rdfThat is the old client/server version of Reports 6i. You cannot use that in Apex. You need the web version if you want to call a report directly from your Apex app.
If a web version is not possible at all, and you really need this report to run from Apex, you may get this to work:
- Create a batch job with dbms_scheduler to run an external command file.
- This command file runs the report using rwrun60.
The problem is where to put this bat file. It will very like not be on the database server, but on some machine where Developer 6i is installed. So, you also need to enable running remote batch jobs with dbms_scheduler.
The problem is, the reports are already developed and now started from a Forms 6i application. That application is migrated to APEX, but they still want to use that old reports. We don't have time to convert them to... I really don't know to what actually...
Simplest way is to start the reports from APEX, if that is possible. What is the Reports server applet you mentioned?
Well, you will need to convert them to a web enabled version of Oracle Reports: http://www.oracle.com/technetwork/middleware/reports/overview/index.html
Then you will be able to call them via an APEX page, using a url to where the middleware is loaded and calling your report..
As noted earlier in the thread, you CAN NOT call a 6i report from a browser...
My suggestion would be, open the report file up in your designer tool, gather the SQL and layout and build NEW APEX Report pages...
You can fiddle around with your old rdf files and possible make them work a while, but in the end, you need to migrate them, since support for Oracle reports will be moving towards BI Publisher...