Re: cursor with dynamic where clause

From: Keld Nielsen <keldnielsen_at_image.dk>
Date: Fri, 17 May 2002 21:06:27 +0200
Message-ID: <XycF8.8769$HN.380206_at_news010.worldonline.dk>


http://asktom.oracle.com
search for ref cursors

"Stefan Röhle" <roehle_at_uni-mainz.de> wrote in message news:3CE4E742.214929F4_at_uni-mainz.de...
> Hi,
>
> I'd like to use a a cursor with a dynamic where clause, for example like
> this:
>
> ------------------
> PROCEDURE diff_test (where_clause in varchar2) IS
>
> cursor cur_test is
> select * from vw_data
> where where_clause;
>
> BEGIN
> [do something]
> END;
> ------------------
> Since this doesn't work this naive way - how can I do it?
>
> Stefan
Received on Fri May 17 2002 - 21:06:27 CEST

Original text of this message