Can you pass a cursor into a procedure?

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. Received on Wed Mar 29 2000 - 12:25:30 CST