Rep-501 (Database Connection) on Report Calling Paramform and RUN_REPORT_OBJECT (Doc ID 382630.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Forms - Version 6.0.8.10.3 to 11.0.0 [Release 6.0.8.10 to 11.0.0]
Information in this document applies to any platform.
***Checked for relevance on 10-Jun-2014***


Symptoms

Reports using a parameter form has been implemented with RUN_REPORT_OBJECT according to the document "Oracle Forms Services – Using Run_Report_Object() to Call Reports with a Parameter Form". When running the report from the form, the parameter form comes up, but when the report is executed it receives an error:

REP-501: Unable to connect to specified database.

Reports that do not use the parameter form run correctly.

When logging into Forms initially, the customer is supplying only the userid / password. The database connect string is supplied by the TWO_TASK environment variable.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms