Bug: 14209

Impact:

Product:
GemConnect

Versions:
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

Platform:
All

Fixed In:

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.