rep-1401: Fatal Error in PL/SQL occured

[Bin Yan]

Hi there,

I encountered the following error message when I run a report:

REP-1401:'beforereport' Fatal PL/SQL Error Occured.

The beforereport trigger calls a PL/SQL packages, which is fairly complicated
package. What it does is to do some calculation according to business rules,
then populate the data to some tables. The packages is successfully compiled.
But each time I run this report, I got this error message. And oracle help
manual doesn't provide much useful hint for this message.

However, if I run this pacakge manually in sqlplus, then run the report.
It works. (in this case, package is not called from report actually). So
the problem looks like the report can't call this package successfully. Does
anyone have the similar problem? How to I correct this?

We are running Oracle 7.3.4.3. Report builder 3.0. PL/SQL 2.3.4.3.0

Any help, hint would be very much appreciated! Thank you all in advance!

Brian Yan

[Shober's]

I think this error is caused by a Function not having a proper Return(Value).
When we whent from reports 2.5 to 3.0 we started picking up this error.
Appartently rules were tightened in 3.0 . In 2.5 it would allow a Function
without a proper Return. Check all Functions, and make sure you provide a
Return(Value) even if a NULL. Sometimes if your Return is in an IF...THEN...ELSE
it won't have a problem with compile, but will cause error on run.

Georgette P Cornio