Re: calling ref cursor function from ASP

In article <1SM55.374$0x.12791_at_nuq-read.news.verio.net>,   "SP" <spant1_at_aol.com> wrote:
> I had posted this message last week also but didn't get any answer.
 So I'm
> trying again.
> I've used ref cursor in my functions to return selected columns. I
 had
> tested the following way from SQLPLUS:
> variable c refcursor
> exec :c := sp_onsale (-1,20)
> print c
> But I don't know how to call the function from ASP. I'd appreciate
 your
> suggestions.
> SP
>
>

\

see http://osi.oracle.com/~tkyte/ResultSets/index.html

there is an example there.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.