Posted by burtonl on 04/27/06 18:46

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.

• Next in forum: Re: running an exec in the background, let page go on.
• Prev in forum: running an exec in the background, let page go on.
• Thread view: calling oracle stored procedure with custom types?

[Reply to this message]