My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2023

Applies to:

Oracle Forms - Version 10.1.2.3.0 to 12.2.1.4.0 [Release 10.1.2.3 to 12.2]
Information in this document applies to any platform.

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 displays 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 <USER_ID> / <PASSWORD>. The database connect string is supplied by the TWO_TASK environment variable.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.