Sequence of Fetching Result Sets and Out Parameters
Oracle stored procedures return result sets in the form of reference cursor parameters. Hence, there is no requirement regarding the sequence in which result sets and OUT parameters are fetched, as both are essentially OUT parameters. Method fetchReturnParams() could be called any time after the stored procedure execution to retrieve the OUT parameters. However, to make your application portable across different access modules, it is recommended to fetch OUT parameters after completely processing the result sets.