SRW.GETERR_RUN
built-in functionThis function returns an error message if Reports Builder detects an error
while running the SRW.RUN_REPORT
procedure.
SRW.GETERR_RUN;
Suppose you are sending parts of a report to users through e-mail. Also, suppose
that if SRW.RUN_REPORT
fails,
you want to display a message that explains why it failed. Your PL/SQL could
look like this:
BEGIN
DECLARE TMP CHAR(100);
begin
srw.run_report('batch=yes report=send.rdf
destype=file desname=send.lis desformat=dflt');
exception when srw.run_report_failure then
tmp := srw.geterr_run;
srw.message(1000, tmp);
end;
END;
About the
Reports Builder built-in package (SRW
)
Copyright © 1984, 2005, Oracle. All rights reserved.