A script-enabled browser is required for this page to function properly.

SRW.DO_SQL_FAILURE built-in exception

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


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

Parameters

Parameter

Description

REP-msg

Is a Reports Builder message..

ORA-msg

Is an optional ORACLE message, providing more information on the Reports Builder message.

Syntax


SRW.DO_SQL_FAILURE;

Usage notes

Reports Builder raises this exception when the SRW.DO_SQL packaged procedure fails (for example, 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.');

See also

About the Reports Builder built-in package (SRW)

SRW built-in package