<< Click to Display Table of Contents >> Current:  Create Data Set > SQL Data Set > Data Set for Stored Procedure  ORACLE Database Returning Data Set(Cursor)

The way of accessing the Oracle database is the same as the way of accessing the DB2 database. If the SQL statements for the stored procedure created in the database are as follows:

CREATE PROCEDURE SCOTT.SP_OUT_JOBS(ret_cursor1 OUT sys_refcursor)

IS

BEGIN

OPEN ret_cursor1 for select * from HR.JOBS;

END;

 

And the call statement written in the SQL statements of Yonghong Z-Suite is Call "CELINA"."SP_OUT_JOBS" (?{out_cursor}), as shown in the following figure.

At the same time, the parameters should be configured, including parameter type, direction and default value etc. as shown in the figure below:

 

The refreshed data is as shown in the figure below: