Bug 14209


2.2, 2.1.1, 2.1, 2.0.1, 2.0, 1.1.6, 1.1.4, 1.1.3, 1.1.2, 1.1.1, 1.0



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

See bugnote #14078 for related information.


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