Search path for Oracle Reports rwservlet

Scott Hollows

Where is the search path for Oracle Reports rwservlet defined ?

When I call an Oracle Report from Oracle Forms (on the same server) the report works correctly

However, when I call the same report via a URL that uses rwservlet, the report can not find the libraries that are attached to the report. It looks like rwservlet is not using the same search path that the regular Oracle Reports server uses, even though rwservlet is running on the same server

Scott Hollows

problem solved

There were two versions of reports.sh file. The search path was defined in one of them

Suresh Sangaran-Oracle

What is the end point URL generated by Oracle Forms --> Oracle Reports and directly you call on browser.

Thanks, Suresh

Scott Hollows

Oracle Forms and Oracle Reports are on the same server.

Oracle Forms runs Oracle Reports by calling the PL/SQL Run_Report_Object procedure. We dont specify the URL for that, we just specify the report name in a parameter

Suresh Sangaran-Oracle

"when I call the same report via a URL that uses rwservlet, the report can not find the libraries that are attached to the report." --->What is the URL you use here? What is the exact error message?

Scott Hollows

problem solved

There were two versions of reports.sh file. The search path was defined in one of them