Re: ADO recordsets using a stored procedure

Hi Lou,

Set rs = DBCon.Execute("select * from pubs")

is the simplest way, why do you need to call a procedure ?

Lou Keeble wrote in message <7av62r$5an$1_at_hirame.wwa.com>...
>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 Wed Feb 24 1999 - 09:56:14 CST