SourcePro DB : DB Access Module for Oracle OCIUser’s Guide : Technical Information : Open SQL and Oracle OCI : OCIStmts : Simultaneous Processing of Results on an RWDBOSql Object When Used for Stored Procedure
Simultaneous Processing of Results on an RWDBOSql Object When Used for Stored Procedure
Multiple result sets produced by a stored procedure execution are handled through additional OCIStmts. To simplify usage, Open SQL does not support simultaneous fetching of multiple result sets. You must complete the current result set, by fetching all the data or canceling, in order to move on to the next result set.