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

Pinkhas Nisanov pinkhas at nisanov.com
Sun Nov 19 01:40:08 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