Cannot get Oracle stored procedure results back
GsOracleConnection only supports the execution of stored procedures
through its executeNoResults: method. Since it does not support
execution of anything other than select statements in its
openCursorOn: and execute: methods (the only methods which actually
return results), it is not possible to obtain stored procedure results
directly.
See bugnote #14078 for related information.
Workaround
Build a PL/SQL block to wrap the stored procedure and store the return
values in a table. Then query the table for results. This requires two
calls to the Oracle database.
Last updated: 9/10/04