The phrase you are almost certainly looking for is ref cursor and there is
an example of this in %ORACLE_HOME%\oledb\samples that should give you a
clue.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
"Lee" <lduhl_at_corp.realcomp.com> wrote in message
news:719532c5.0408250726.4ed17764_at_posting.google.com...
> We are in the process of attempting a conversion of a large ASP/MS SQL
> 7.0 application to ASP/Oracle 10g and we are having major problems.
>
> We are new to Oracle and struggling with the basics. We are having
> major issues just trying to get a recordset returned to our ASP app
> from an Oracle stored proc.
>
> I would like to know if someone can supply us with a sample of a
> simple Oracle (9i r2 or greater) stored proc that returns a multi
> record recordset and also a sample of the ASP code that created the
> connection, recordset, param and command objects to call the sample
> stored proc and return the result set to the ASP recordset object.
>
> We are using the latest version of the Oracle Data Provider for OLEDB
> (Provider=OraOLEDB.Oracle.1)
>
> Thanks in advance.
> Lee
Received on Wed Aug 25 2004 - 16:28:15 CDT
