Skip to Content
0
Former Member
Mar 31, 2009 at 06:35 PM

Can we receive a cursor from native SQL as out parameter directly

32 Views

Hi,

Can we receive a cursor as an out parameter from an Oracle stored procedure directly into an internal table with multiple rows on the SAP sap. Something like this?

EXECUTE PROCEDURE iplan_adm.ZPKG_IPLN_AATP.SAP_Interface

(in :r_type,

in :r_matnr,

in :r_quantity,

in :r_kunnr,

in :r_SAP_sequence_no,

in :r_vbeln,

in :r_reschedule_flag,

in :r_old_CRD_date,

in :r_new_crd,

in :r_new_order_qty,

in :r_ord_type,

out :t_output_rows)

Or do I always have to open a cursor from SAP side and get the data row by row from the internal table?