Re: Help: Dynamic where clause in a PL/SQL procedure

Muhammad Ahmad Malik wrote:
>
> 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

Yes, find the code for the dbms_sql package. You can do any pl/sql not just where clauses. The package source includes ample docs.

Loyal Received on Tue Nov 05 1996 - 00:00:00 CST