[Israel.pm] perl and oracle: bind array input

Pinkhas Nisanov pinkhas at nisanov.com
Sun Nov 19 04:45:59 PST 2006


Hi,

I got mail with question about using array with DBD::Oracle:
 > We are trying to look into the ability to use Array's or custom types 
as IN/OUT parameters,
 > while using Perl.  We can do this just fine in Java, but have one 
legacy application
 > that we need to port to the new procedure formats.

 > CREATE TYPE TEST_TYPE AS OBJECT(ID NUMBER,ADDRESS VARCHAR2(4000));
 > CREATE TYPE TEST_TYPE_ARRAY AS TABLE OF TEST_TYPE;
 > TEST_ARRAY_PROCEDURE(P_TEST_ARRAY IN OUT TEST_TYPE_ARRAY);

I know it was problem in previous versions of DBD::Oracle,
but I saw there was new release ( 1.19 ) recently.
Is there something new?

thanks
Pinkhas Nisanov



More information about the Perl mailing list