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 OCTOBER 15, 2012

Applies to:

Oracle Reports Developer - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

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
The beside 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

None, just take a working reports from 10gR2 and compile it in 11g, there are no compilation errors

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