srw-geterr_run

Description  This function returns an error message if Report Builder detects an error while running the SRW.RUN_REPORT procedure.

Syntax           SRW.GETERR_RUN;

Returns  An error message.

Example

/* Suppose you are sending parts of a report to users via Oracle*Mail.  ** For more information, see “SRW.RUN_REPORT”.   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;