Re: Where clause in a host variable?

From: Roger Snowden <snowden_at_haven.ios.com>
Date: 1995/09/19
Message-ID: <43n2b4$dij_at_news.ios.com>#1/1

JoeyWhite (joeywhite_at_aol.com) wrote:

: Does anybody know if it is possible to have the where clause passed into a
: package function as a host variable type parameter? The function is
: written in PL/SQL (obviously...)

The package you need is dbms_sql.sql, which comes with Oracle. It is on (UNIX) $HOME/rdbms/admin. Read the script itself, then call Oracle and ask for the faxback document on dbms_sql. The cd-rom documentation on this subject is incorrect, so disragard it. Rhe fax is actually pretty good. Also, there was an article a couple of issues ago in Oracle magazine that had a pretty good discussion of dynamic sql with pl/sql. The magazine is a freebie and they will generally send back issues on request. Call Oracle to get the number for the magazine.

Roger Received on Tue Sep 19 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Roger Snowden: "Re: Foreign key constraints or indexes...which comes first?"
Previous message: Jim Gregory: "Re: Oracle Hung during Shutdown"
In reply to: JoeyWhite: "Where clause in a host variable?"
Next in thread: Roger Snowden: "Re: Foreign key constraints or indexes...which comes first?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message