[Israel.pm] perl and oracle: bind array input
pinkhas at nisanov.com
Sun Nov 19 01:40:08 PST 2006
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?
More information about the Perl