stored precedures with array as parameter

From: Frank Motzkat (Frank.Motzkat_at_ic3s.de)
Date: 06/21/04 

To: dbi-users@perl.org
Date: Mon, 21 Jun 2004 17:11:45 +0200

Hi all,

I'm looking for a way to call stored precedures directly with one or more
arrays as input parameter via DBD:Oracle interface.
Does anybody has a hint for me how I can do this ?

Let me say that the function that I would like to call looks similar to
the one below:

CREATE OR REPLACE PACKAGE mystorage IS
  TYPE my_tagnames IS TABLE OF varchar2(200) INDEX BY BINARY_INTEGER;

FUNCTION insert_sm (msgid IN varchar2,
                        tagnames IN my_tagnames,
                        tagvalues IN my_tagnames,
                        sf_info OUT VARCHAR2
                       ) RETURN NUMBER;

 
END mystorage;
/

How should the prepare statement look like and how can I forward the
array's to the function ?

Thank for any help in advance !

kind regards,

frank