ADO recordsets using a stored procedure

I want to get an ADO recordset in an ASP script using a stored procedure. How do I do that with Oracle?

With SQL Server/Transact-SQL I could write:

create procedure myproc
as
select * from pubs

and I could get the recordset using

Set rs = DBCon.Execute(myproc)

With Oracle it does not appear to be so simple

Thanks,

            -Lou Keeble Received on Tue Feb 23 1999 - 15:20:43 CST