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_at_cs.wmich.edu>#1/1
end;
Date: 1996/11/04
Message-ID: <327E3FE2.185D_at_cs.wmich.edu>#1/1
[Quoted] [Quoted] I want to pass as a variable the "where clause" for a cursor in the [Quoted] [Quoted] 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_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