469,645 Members | 1,424 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

calling oracle stored procedure with custom types?

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.

Apr 27 '06 #1
1 3187
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/
May 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by stephane.traumat | last post: by
1 post views Thread by Jason Leiser | last post: by
1 post views Thread by Chad | last post: by
3 posts views Thread by RicercatoreSbadato | last post: by
1 post views Thread by C#_Beginner | last post: by
4 posts views Thread by raghuvendra | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.