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)}