Re: Dynamic SQL in Stored Procedures

From: Scott Urman <surman_at_oracle.com>
Date: 1995/11/19
Message-ID: <48obd8$ela_at_inet-nntp-gw-1.us.oracle.com>#1/1

In article <48geik$c61_at_clarknet.clark.net>, costello_at_clark.net (Matthew C. Costello) writes:
|> Is it possibe to define a select inside a Stored Procedure (using some
|> input parameters and string concatenation) and then execute it within
|> the procedure?
|>
|> I'm using 7.1.3 Workgroup/NT and it seems that pl/sql only wants
|> statically defined SQL.
|>
|> Thanks!
|>
Yep. Check out the DBMS_SQL package, documented in the Oracle7 Server Documentation Addendum and online in dbmssql.sql. Received on Sun Nov 19 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Rick Greenwald: "Re: Power Objects Questions"
Previous message: mhaldey_at_ozemail.com.au: "Re: Splitting this newsgroup ?"
In reply to: Matthew C. Costello: "Dynamic SQL in Stored Procedures"
In reply to Matthew C. Costello: "Dynamic SQL in Stored Procedures"
Next in thread: Rick Greenwald: "Re: Power Objects Questions"
Reply: Robert Goodwin: "Re: Dynamic SQL in Stored Procedures"

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

Original text of this message