rep-1401: Fatal Error in PL/SQL occured
Date: 4 Feb 1999 19:46:59 GMT
Message-ID: <79ctfj$a2u$1_at_scapa.cs.ualberta.ca>
[Quoted] 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 Thu Feb 04 1999 - 20:46:59 CET