Rep-1401 and ORA-00936 Running in 11g an Upgraded Report which is using a Hint with Syntax --+
(Doc ID 1423500.1)
Last updated on FEBRUARY 27, 2019
Applies to:
Oracle Reports Developer - Version 11.1.1.4.0 and laterInformation in this document applies to any platform.
*** Checked for relevance on 27-Feb-2019 ****
Symptoms
When attempting to run/deploy one particular report the following error occurs.
ERROR
-----------------------
REP-1401 'A Fatal PL/SQL error occurred in program unit <name>'.
without further details if the Report runs using the Reports Server.
But if the same report is run using Reports Builder
Then besides the REP-1401 it will show the error ORA-00936, Missing Expression.
The issue can be reproduced at will with the following steps:
1. compile this migrated report from 10g in 11g and notice there are No error
2. Run the report in Reports Server 11g using the same database connection as in 10g
3. Test the same report in Reports Builder to get more details on the error
What is Working
============
The same report runs fine using a Reports Server 10g.
Running the PLSQL program unit were the error is detected outside Reports (i.e sql*plus), it works without issue.
Changes
Upgrade reports from 10gR2 and compile it in 11g.
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 |