REP-1401: "beforetrigger", Fatal PL/SQL error occured

[Bin Yan]

Hi there,

I encountered an error when I run a report from report builder. The
error message is:

REP-1401: 'beforereport', Fatal PL/SQL error occured

In the before report trigger, report calls a fairly complicated package.
what this package does is to do some calculation per business rules,
then populate the data to some tables. The package is successfully
compiled. It can be successfully completed in SQLPLUS.

However, if I run the package manually in SQLPLUS, then run the report
(in this case, the package inside the beforereport trigger actually is
not executed). It works fine. It looks like the package can not be
called successfully by the beforereport trigger.

We are using Oracle7.3.4, report builder 3.0. Does anyone have the
similar problem? what causes this problem? 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

[Bahar Leblebici]

>

This error occured in our reports after we migrate to reports 3.0. We
had a function in our report's beforereport trigger, and it was
correctly coded (as we tried in on SqlPlus). But at runtime it returned
REP-1401. We found that our function had two IN OUT parameters (in 7.3.4
database a parameter can be IN OUT), and when we changed one of the
parameters IN no error occured. As you are using 7.3.4, I recommend you
to check your parameter types.
Bahar Leblebici