Skip to Main Content

REP-1401: A fatal PL/SQL error occurred in program unit beforereport.

bootstrapMay 2 2016 — edited May 3 2016

There is a surprising issue with report in 11g.

Earlier the report was run in 6i version. We need to move it to 11g (on unix terminal). So for that we are compiling the same file in 10g. In 10g everything is fine.

But when the same file is moved to Oracle 11g on Unix terminal we are getting below error.

REP-1401: A fatal PL/SQL error occurred in program unit beforereport.

ORA-01403: no data found

Data is present in the database but even then report is throwing "no data found" exception.

Why the same file is behaving differently in 10g and 11g? Any solution for this ?

Comments
Post Details
Added on May 2 2016
18 comments
21,499 views