Skip to Content
0
Former Member
Aug 16, 2017 at 05:08 PM

SAP PI - Execute stored procedure with custom type using Statement

54 Views Last edit Aug 16, 2017 at 08:15 PM 2 rev

Hey folks,

I need your help, I tried to call a stored procedure that has custom type as IN/OUT with inner fields. How could I execute using Statement?

TYPE STATUS_ROW IS RECORD (
  P_INVOICE_NUMBER VARCHAR2(255),
  P_INVOICE_STATUS VARCHAR2(255));
TYPE STATUS_TABLE IS VARRAY(2000) OF STATUS_ROW;

PROCEDURE INVOICE_STATUS (P_STATUS IN OUT STATUS_TABLE);

Thx in advance.