SRW.MAXROW_UNSET
built-in exceptionThis 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.
SRW.MAXROW_UNSET;
Reports Builder raises this exception when the SRW.SET_MAXROW
packaged procedure is called after the query's records have already been fetched.
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.');
About the
Reports Builder built-in package (SRW
)
Copyright © 1984, 2005, Oracle. All rights reserved.