Help: Dynamic where clause in a PL/SQL procedure

I want to pass as a variable the "where clause" for a cursor in the procedure. There must be someway to handle this. Unfortunatly I don't have the manuals.

Example:

create or replace procedure dempno(where_clause varchar) as

	cursor c is select empno from emp where_clause;
--				         ^^^^^^^^^^^^^^

	dbms_output.enable;
	open c;
	loop
		fetch c into emp_rec;
		exit when c%notfound;
		dbms_output.put_line(emp_rec);
	end loop;
	close c;

Thanks in Advance.

--

Muhammad Ahmad Malik
Western Michigan University
mamalik_at_cs.wmich.edu - http://www.wmich.edu/frc/ahmad.html +1 (616) 373-3065 Received on Mon Nov 04 1996 - 00:00:00 CET