srw-do_sql_failure

Description  This exception stops the report execution and raises the following error message:

REP-1425: Error running DO_SQL package – REP-msg ORA-msg

where:

REP-msg        Is a Report Builder message.

ORA-msg       Is an optional ORACLE message, providing more information on the Report Builder message.

Syntax

SRW.DO_SQL_FAILURE;

Usage Notes  Report Builder raises this exception when the SRW.DO_SQL packaged procedure fails (e.g., if the user does not have DDL privileges, yet tries to create a table with SRW.DO_SQL).

Example

/* Suppose you want your own error message raised,

** instead of the default error message.

** You could handle this exception in the following way:

*/

EXCEPTION

when SRW.DO_SQL_FAILURE then

   srw.message(1000, ‘Error occurred while creating

               table CHECKS.’);