DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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 ?

This post has been answered by bootstrap on May 3 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2016

Added on May 2 2016

#reports

18 comments

32,008 views