Re: Can you pass a cursor into a procedure?

Please post a sample code, or a URL to where this code can be seen.

In article <8bthq5$e05$1_at_nnrp1.deja.com>, Sean <dolans_at_my-deja.com> wrote:
> Pardon me if this is a dumb question, but I can't figure out how to do
> this. I have a PL/SQL package that has 4 defined cursors : each
> returns two columns but are based on a lot of different WHERE, IN, and
> EXISTS clauses.
>
> I would like to base which cursor is used based on the parameters that
> are passed into the calling main procedure. No problem. I can get
> what cursor to use. I can get the results and they successfully are
> inputted into a PL/SQL table. What I would like to do is make a
> procudure/function that I can just pass which cursor to use in, let it
> find the answers, and then put the results into the PL/SQL table
> structure.
>
> Am I going about this wrong? I'd appreciate any help.
> Thanks,
> Sean
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
If the human brain were so simple
that we could understand it,
we would be so simple we couldn't.
-Makes Sense... don't it?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 14:33:44 CST