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

SRW.NULL_ARGUMENTS built-in exception

This 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>.

Syntax


SRW.NULL_ARGUMENTS;

Usage notes

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:

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.NULL_ARGUMENTS then 
  SRW.MESSAGE(4000, 'Contact Application Development 
  regarding SRW.NULL_ARGUMENTS.');
  raise SRW.PROGRAM_ABORT;

See also

About the Reports Builder built-in package (SRW)

SRW built-in package