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

In article <327E3FE2.185D_at_cs.wmich.edu>, mamalik_at_cs.wmich.edu 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
>
You need to use dynamic pl/sql. It's available in a package from Oracle - I think it first shipped with 7.1

The details are a bit gory - if you don't have the manuals, pick up a book on pl/sql or check the Oracle web site.

Eric