Nonstop Database, HiRDB Version 9 UAP Development Guide
To receive a dynamic result set by invoking a procedure that returns a dynamic result set, use the getNextResultSet() method for the execution context. For the native interface edition, a procedure that returns a dynamic result set cannot be used because JDBC result sets cannot be used.
The getNextResultSet() method returns a dynamic result set (ResultSet object) as a return value. Every time this method is invoked, it returns the next result set. After it returns the last result set, it returns a null value.
For a procedure or SQL statement that does not return a dynamic result set, a null value is returned. A null value is returned also when SQL execution is not normally terminated.
If an error occurs during the execution of the getNextResultSet() method, the SQLException occurs.
An example follows:
#sql [execCtx] { CALL MULTI_RESULTS() }; ResultSet rs; while((rs == execCtx.getNextResultSet() ) != null){ processing-of-the-retrieval-result; rs.close(); } |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.