Bug 14209

GemConnect

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

All

2.3

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