Re: rep-1401: Fatal Error in PL/SQL occured

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

Bin Yan wrote:

> 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
Received on Sat Feb 06 1999 - 03:39:36 CET