Help: Dynamic where clause in a PL/SQL procedure

From: Muhammad Ahmad Malik <mamalik_at_cs.wmich.edu>
Date: 1996/11/04
Message-ID: <327E3FE2.185D@cs.wmich.edu>#1/1

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;
 --                                       ^^^^^^^^^^^^^^

• How can I handle this part

         emp_rec emp.empno%type;
 begin

         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;

 end;  

 Thanks in Advance.  

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