Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
April 27, 2006, 3:46 pm
rate this thread
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:
( key_tbl OUT NOCOPY VARCHAR2_3200_ARRAY,
value_tbl OUT NOCOPY NUMBER_ARRAY,
refresh_type IN VARCHAR2
Can anyone suggest how to call this?
Re: calling oracle stored procedure with custom types?
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.
- » running an exec in the background, let page go on.
- — Previous thread in » PHP Scripting Forum