[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