Unanswered: How to pass array to strored procedure?
I have a procedure which defined as follows:-
TYPE v_criteria IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
TYPE t_refcursor IS REF CURSOR;
PROCEDURE test_proc(p_search IN v_criteria, p_resultset OUT t_refcursor);
I plan to write a C# program which passes an array of string to the above procedure. How can I do that? I have searched through the Oracle documentation which mentioned about Array Binding but its not exactly what I need.