I wonder how can one handle errors raised during report execution. Suppose I have a report and it's stopping execution due to some Oracle error. I need to log the error in a table. Oracle Reports do not, however, contains any trigger similar to ON-ERROR in Oracle Forms. What to do with this?
Thanks in advance,
P.s. We're still using Oracle Reports/2000, unfortunately. Then we migrate to 10g.
---------- Edited by: JackK on Apr 5, 2012 6:49 AM
No one can help me? :(
I don't know for the Reports 2.5 your are using, but you can use the trace file to log errors (not in the database, but in a file). In 6i it would be a command line like:
RWRUN60 MODULE=demo USERID=a/b@c tracefile=c:\temp\trace.log traceopts=trace_err trace_mode=trace_replace
Errors in pl/sql program units can be caught by your own exception handler.
It's not what I was expected. I am looking for a sollution which will handle every unhandled exception in such functions. Your sollution wouldn't for example handle exception ORA-00904 in report's query. I need a "general handler".
Same for 10g: the is no such thing in Reports as a general on-error trigger.
However, in 10g the error is visible in the Reports job queue. You can see the job queue via the URL:
You would see an error like this:
Terminated with error: <br>REP-300: : invalid identifier