Skip to Content
0

SAP PI - Execute stored procedure with custom type using Statement

Aug 16, 2017 at 05:08 PM

21

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers