Posted by Christopher.Jones on 05/08/06 05:07

burtonl@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: Christopher.Jones@oracle.com
Blog: http://blogs.oracle.com/opal/

• Next in forum: Upload Progressbar
• Prev in forum: Re: open-source web design and hosting firm for non-profit?
• Thread view: Re: calling oracle stored procedure with custom types?

[Reply to this message]