Re: Can I Select data from Procedure/Function?

My Select statement returns many rows back. And the procedure will be called by ASP (Active Server Pages).

By the way, as my experience, it is hard to call Oracle Function from ASP. ASP always report error in either "ORA-4043" or "Parameter not suitable..." from ASP.

Thank you very much.

> In article <3A7777F6.2C501F05_at_hknet.com>,
> Diviner <diviner_at_hknet.com> wrote:
> > I have a complex Select statement and want to wrap it up.
> > Does Oracle has any machanism for me to do this?
> >
> > Thank you very much.
> > --
> > Best regards,
> > Diviner.
> >
> >
> Does it return one value, one row, or many values/rows?
> Do you intend to call it from SQL*PLUS, PL/SQL, or another
> language (e.g., Pro*C)?
>
> The mechanism is different depending on your answers.
>
> If it returns a single value, make it a PL/SQL function.
>
> If it returns a single row, then a simple PL/SQL procedure.
>
> If it returns many rows, then a more complex PL/SQL procedure.
>
> Tell us more so we can help.
>
> --
> Ed Prochak
> Magic Interface, Ltd.
> ORACLE Development, conversions, training and support
> 440-498-3700 magic_at_magicinterface.com <<<WE MOVED!
>
> Sent via Deja.com
> http://www.deja.com/
  Received on Wed Jan 31 2001 - 03:00:54 CST