Oracle 11g recent upgrade - How do I prevent a report with parameters from relogging into the DB aft
Oracle 11g recent upgrade
How do I prevent a report with parameters from relogging into the DB after clicking the "Submit Query" which invokes the PFACTION? Same report/form combination worked in 10g forms/reports.
Launching the report from forms creates the expected second DB session but an additional login to the DB in the same session results in the loss of the session roles established on initial report launch from forms.
We did not have SSO configured in 10g so I assumed we wouldn't have to use it in 11g.
Any assistance would be greatly appreciated.
Eugene Outley