Re: Stored procedure that returns a recordset?

On 16 Aug 2003 12:08:34 -0700, rchin_at_panix.com (Robert C) wrote:

>procure rctest (p_rc in out rcur, p_table in varchar2 default 'emp') ;

Pretty much, but I'd recommend making the output cursor the last parameter in the procedure. IIRC, ADO or OLE-DB has some problem with procedure calls where there are more than two parameters, where one of those is an output ref cursor, and it isn't the last one.

Also note, if you call the procedure by creating an ADO.Command object and appending Parameter objects, don't create one for the output ref cursor.

cheers,
Ross.

--
Ross McKay, WebAware Pty Ltd
"Since when were you so generously inarticulate?" - Elvis Costello