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

SRW.MAXROW_UNSET built-in exception

This exception temporarily stops the report execution and raises the error message below. After the message is raised and you accept it, the report execution will continue.


REP-1423: Cannot set maximum rows of the query after it started executing.

Syntax


SRW.MAXROW_UNSET;

Usage notes

Reports Builder raises this exception when the SRW.SET_MAXROW packaged procedure is called after the query's records have already been fetched.

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.MAXROW_UNSET then 
  SRW.MESSAGE(1000, 'Data was fetched before
  SRW.SET_MAXROW was called.'); 

See also

About the Reports Builder built-in package (SRW)

SRW built-in package