calling oracle stored procedure with custom types?

[burtonl]

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_array 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_ARRAY,
value_tbl OUT NOCOPY NUMBER_ARRAY,
refresh_type IN VARCHAR2
)

Can anyone suggest how to call this?
Thanks.

[Christopher.Jones]

bu*****@gmail.com writes:

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_array 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_ARRAY,
value_tbl OUT NOCOPY NUMBER_ARRAY,
refresh_type IN VARCHAR2
)

Can anyone suggest how to call this?
Thanks.

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->_connectionID. 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: Ch***************@oracle.com
Blog: http://blogs.oracle.com/opal/