Re: Dynamic queries in PL/SQL
From: Kevin Skelton <kskelton_at_earth.execpc.com>
Date: 1996/02/02
Message-ID: <4eu0se$bea_at_daily-planet.execpc.com>#1/1
: |> 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)...
Date: 1996/02/02
Message-ID: <4eu0se$bea_at_daily-planet.execpc.com>#1/1
: In article <3110C5C7.63A0_at_gmc.ulaval.ca>, Charles Vaillancourt <charles_at_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
Received on Fri Feb 02 1996 - 00:00:00 CET