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

From: Jerry Bull <gbbull_at_uswest.com>
Date: 1996/11/04
Message-ID: <327E65EF.3928_at_uswest.com>#1/1

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.
>

Look at the package DBMS_SQL. This allows you to dynamically build the entire statement. It takes a little more coding than you show, but it works pretty well.

Jerry.

---

Jerry Bull, Sr. MTS         Phone: 303-624-3073
U S WEST Technologies       Fax:   303-624-8462

931 14th Street, Suite 920 Email: gbbull_at_uswest.com Denver, CO 80202

---

Received on Mon Nov 04 1996 - 00:00:00 CET