Re^2: Passing arrays to an oracle stored procedure

Thanks for the replies. But my requirement is something like this.

Input to my stored procedure is an associative array.

TYPE msg_comp IS TABLE OF VARCHAR2(40) INDEX BY 
VARCHAR2(100);

TYPE messages_table IS TABLE OF VARCHAR2(200);

TYPE message_versions_tt IS TABLE OF SOME_TABLE%ROWTYPE;

PROCEDURE get_message_versions(
          msg_comp_names IN msg_comp,
          message_versions OUT message_versions_tt  );
[download]

So this procedure takes in an associative array as an input and returns a set of rows as a table.

How do I call this procedure from perl using DBI?
That is how to I bind a perl hash to an oracle associative array?

Comment on Re^2: Passing arrays to an oracle stored procedure Download Code

Replies are listed 'Best First'.
Re^3: Passing arrays to an oracle stored procedure by Anonymous Monk on Aug 23, 2013 at 09:13 UTC
I am new to 'perl to DB' communication and I have same question. How to bind perl hash to associative array (or nested table) and pass it to procedure from a perl program?	[reply]