I have a legacy procedure that returns a plsql assoc table to a C++ DLL. Now I need to call it via C# and ODP.NET. I have been unable to find any info on how to call a proc that returns a pl/sql assoc array (plenty on how to send data to one that takes as an input).
Thinking that if I can have the proc return a ref cursor then it should not be an issue since I have done it plenty of times
However, have not found examples of doing that and all attempts have failed.
Any help would be welcomed.
code below. it provides an orderid as input. it calls another proc relOrders that returns an array that is put into pl sql table.
TYPE tab_number12 IS TABLE OF NUMBER (12) INDEX BY BINARY_INTEGER; PROCEDURE GetOrders (p_Orderid IN NUMBER, p_subOrderIds OUT tab_number12) IS allOrder DBMS_SQL.number_table; BEGIN allOrder (1) := p_Orderid; relOrders (allOrder); FOR i IN allOrder.FIRST .. allOrder.LAST LOOP p_subOrderIds (i) := allOrder (i); END LOOP; END;