cursor with dynamic where clause

From: Stefan Röhle <roehle_at_uni-mainz.de>
Date: Fri, 17 May 2002 13:19:30 +0200
Message-ID: <3CE4E742.214929F4_at_uni-mainz.de>

Hi,

[Quoted] [Quoted] 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 - 13:19:30 CEST