FRM-41214 and REP-501 when connecting to Database 11g using "RUN_REPORT_OBJECT"
(Doc ID 469013.1)
Last updated on JULY 25, 2023
Applies to:
Oracle Forms - Version 10.1.2.3.0 to 10.1.2.3.0 [Release 10.1.2.3]Oracle Reports Developer - Version 9.0.4.0 to 10.1.2.3 [Release Oracle9i to 10gr2]
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Symptoms
When running Reports from Forms using “RUN_REPORT_OBJECT”, the following errors occur:
REP-501: Unable to connect to the specified database.
FRM-41214: Unable to run report
Users connect to Forms successfully by entering Username/Password@DB in the Forms default login
screen.
Issue occurs with all reports, but only when connecting to an 11g database.
OR
When running the command EXEC_SQL.OPEN_CONNECTION('user/pwd@db_alias'); an ORA-306500 error is thrown when connecting to the 11g database, but not when connectiing to earlier versions of the database.
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 |
Cause |
Solution |
References |