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.');
