Adding the OUT CURSOR parameter in the stored procedure invocation
If a stored procedure is used in the Inbound Read Action for the Oracle
database, you must manually add the OUT CURSOR
parameter.
This goes in the right position of the stored procedure invocation to retrieve the result
set.
For example, when using this stored procedure definition in the Oracle database:
create or replace procedure sp_dbp_read(out_var out sys_refcursor)
IS
BEGIN
open out_var for select * from TABLE_SANITY where TABLE_SANITY.FLAG=0 order by TABLE_SANITY.ID;
END;
Set the stored procedure initiation in the Inbound Read Action as:
{call sp_dbp_read(rowset OUT CURSOR)}