title: ODP.net pass UDT as table to a stored procedure in C#
body: <p>I have a custom Type which looks like this</p>
  
  <pre><code>create or replace TYPE order_type AS OBJECT
  (
     order_type VARCHAR2 (50),
     quantity VARCHAR2 (50),
     price NUMBER,
  
  );
  </code></pre>
  
  <p>Table defined as below</p>
  
  <pre><code>create or replace TYPE order_tabtype AS TABLE OF order_type;
  </code></pre>
  
  <p>Stored Procedure</p>
  
  <pre><code>  PROCEDURE create_order (acc_number  VARCHAR2,
                              order_items devs.order_tabtype,
                              confirmation_num OUT VARCHAR2)
     IS
  </code></pre>
  
  <p>How should I prepare my C# classes to make my stored procedure call to work. 
  Most of the examples I referred either pass UDT as array or there is only table of default type.But I need to pass Custom Type as Table. </p>