calling oracle stored procedure with custom types?

[burtonl@gmail.com]

I'm using the ADODB abstraction layer and trying to figure out how to
call an Oracle stored procedure.

It has the following types defined:

CREATE OR REPLACE TYPE varchar2_3200_a rray IS TABLE OF VARCHAR2(3200);
/
CREATE OR REPLACE TYPE number_array IS TABLE OF NUMBER;
/


The procedure parameters look like:

PROCEDURE testproc
( key_tbl OUT NOCOPY VARCHAR2_3200_A RRAY,
value_tbl OUT NOCOPY NUMBER_ARRAY,
refresh_type IN VARCHAR2
)

Can anyone suggest how to call this?
Thanks.

[Christopher.Jones@oracle.com]

Re: calling oracle stored procedure with custom types?

burtonl@gmail.c om writes:
[color=blue]
> I'm using the ADODB abstraction layer and trying to figure out how to
> call an Oracle stored procedure.
>
> It has the following types defined:
>
> CREATE OR REPLACE TYPE varchar2_3200_a rray IS TABLE OF VARCHAR2(3200);
> /
> CREATE OR REPLACE TYPE number_array IS TABLE OF NUMBER;
> /
>
>
> The procedure parameters look like:
>
> PROCEDURE testproc
> ( key_tbl OUT NOCOPY VARCHAR2_3200_A RRAY,
> value_tbl OUT NOCOPY NUMBER_ARRAY,
> refresh_type IN VARCHAR2
> )
>
> Can anyone suggest how to call this?
> Thanks.
>[/color]

There isn't any Oracle collection support in ADOdb. If you add it,
let John Lim know at http://phplens.com/lens/adodb/docs-oracle.htm

If you really want to live dangerously, you can hack a temporary
solution that will be unstable, likely to break other ADOdb features,
and likely to break in a future release of ADOdb, by mixing ADOdb and
oci8 calls. ADOdb's underlying oci8 connection resource is in
$DB->_connectionI D. I don't recommend doing this.

There are collection examples with the oci8 driver on the web,
including the PHP code at the foot of http://blogs.oracle.com/opal/2006/04/21#a20

--
Christopher Jones, Oracle Corporation, Australia.
Email: Christopher.Jon es@oracle.com
Blog: http://blogs.oracle.com/opal/