From: kskelton@earth.execpc.com (Kevin Skelton)
Subject: Re: Dynamic queries in PL/SQL
Date: 1996/02/02
Message-ID: <4eu0se$bea@daily-planet.execpc.com>#1/1
distribution: world
references: <3110C5C7.63A0@gmc.ulaval.ca> <4er2mp$6na@inet-nntp-gw-1.us.oracle.com>
organization: Exec-PC
newsgroups: comp.databases.oracle


: In article <3110C5C7.63A0@gmc.ulaval.ca>, Charles Vaillancourt <charles@gmc.ulaval.ca> writes:
: |> Little question from a novice: is it possible to compose a query
: |> dynamically in PL/SQL? i.e. reading a query from a record and executing
: |> it or building a query in a text-variable and executing it.  I can do
: |> it remotely with a tool like Delphi but I would like to do server
: |> processing on the results (i.e. in a stored proc)...

Yes, the DBMS_SQL Package works well.  Steve Feuerstein's book, "Oracle 
PL/SQL Programming" has a good example of it use.

Kevin Skelton
Mortgage Guaranty Insurance Corp. 
Milwaukee, WI