Sequence of Fetching Result Sets and Out Parameters

SourcePro DB : DB Access Module for Sybase User’s Guide : Technical Information : Open SQL and Sybase Open Client Client-Library : Stored Procedures and Open SQL : Sequence of Fetching Result Sets and Out Parameters

For Sybase stored procedures that return a result set, the Open-Client Client Library returns the OUT parameters only after the result sets are returned. Hence, you should call fetchReturnParams() only after completely processing all the result sets. Calling this method before processing the result sets cancels the result sets.