Rep-501 (Database Connection) on Report Calling Paramform and RUN_REPORT_OBJECT
Last updated on MAY 12, 2017
Applies to:Oracle Forms - Version 126.96.36.199.3 to 11.0.0 [Release 188.8.131.52 to 11.0.0]
Information in this document applies to any platform.
***Checked for relevance on 10-Jun-2014***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms