variables in cursors

I'm new to PLSQL..

How do I do this:
I'm trying to write a procedure that takes in 2 variables, and puts out a PL/SQL table
something like

procedure generic_get_distinct (field in varchar2, table in varchar2, OUT someting)
IS
cursor is select distinct field from table; // where field and table are variables passed into the proc.

begin
.... some code
End generic_get_distinct;

How do I get the cursor to use the values of field and table passed to it?

thank you Received on Fri May 29 1998 - 15:06:09 CDT