SRW.DO_SQL_FAILURE
built-in exceptionThis exception stops the report execution and raises the following error message:
REP-1425: Error running DO_SQL package - REP-msg ORA-msg
Parameter |
Description |
|
Is a Reports Builder message.. |
|
Is an optional ORACLE message, providing more information on the Reports Builder message. |
SRW.DO_SQL_FAILURE;
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
).
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.');
About the
Reports Builder built-in package (SRW
)
Copyright © 1984, 2005, Oracle. All rights reserved.