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

Hi, Muhammad!

I think there is no simple way to do such thing. You have to use dynamic SQL (dbms_sql package).

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_at_cs.wmich.edu - http://www.wmich.edu/frc/ahmad.html
> +1 (616) 373-3065
 

-- 
Regards. Alexey Neckrasow. Leaves Inc. Russia.