How to call Oracle Record type with Oracle Table type variable from C# by procedure

See more:

C#

Oracle

I have Oracle package like:

create or replace PACKAGE pkg_OrderProcessingbyUser AS

     TYPE RECORDTBL IS RECORD (
         ROLEID CHAR(19),
         ROLEACTION CHAR(2)
      );
    TYPE people_typ IS TABLE OF RECORDTBL INDEX BY BINARY_INTEGER;

   PROCEDURE Pro_Temp(rolearrayval IN people_typ);
end;

And the Package Body as:

create or replace PACKAGE BODY pkg_OrderProcessingbyUser AS
PROCEDURE Pro_Temp(rolearrayval IN people_typ)IS
   BEGIN
      FOR i IN rolearrayval.FIRST .. rolearrayval.LAST
      LOOP
       DBMS_OUTPUT.PUT_LINE(rolearrayval(i).ROLEID||' '||rolearrayval(i).ROLEACTION);
      END LOOP;
   END;
  END pkg_OrderProcessingbyUser;

Which can be called from Oracle Sql Editor like:

SET SERVEROUTPUT ON;
 declare 
  people_typ_par pkg_OrderProcessingbyUser.people_typ;
 begin
  people_typ_par(1).ROLEID:='ZZZZ';
  people_typ_par(1).ROLEACTION:='A';
  PKG_ORDERPROCESSINGBYUSER.Pro_Temp(people_typ_par);
end;

Up to This point every thing is working fine, but how can we call this Procedure with parameter value from C#, can any one help me to call this scenario from C# as procedure call.