SRW.NULL_ARGUMENTS
built-in exceptionThis exception stops the report execution and raises the following error message:
REP-1418: Passed null arguments to <SRW.DO_SQL or SRW.MESSAGE or SRW.RUN_REPORT or SRW.SET_MAXROW or SRW.USER_EXIT>.
SRW.NULL_ARGUMENTS;
Reports Builder raises this exception when one of its packaged functions or
procedures is called with a missing argument. This exception is useful when
you pass argument values to a packaged function or procedure, and you want to
ensure that the values passed are not NULL (for example, when a formula column
calls SRW.USER_EXIT
, and the user exit string is passed from a
PL/SQL library).
The following could raise this exception:
SRW.DO_SQL
SRW.MESSAGE
SRW.RUN_REPORT
SRW.SET_MAXROW
SRW.USER_EXIT
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.NULL_ARGUMENTS then
SRW.MESSAGE(4000, 'Contact Application Development
regarding SRW.NULL_ARGUMENTS.');
raise SRW.PROGRAM_ABORT;
About the
Reports Builder built-in package (SRW
)
Copyright © 1984, 2005, Oracle. All rights reserved.