Dynamic SQL in Stored Procedures

From: Matthew C. Costello <costello_at_clark.net>
Date: 1995/11/16
Message-ID: <48geik$c61_at_clarknet.clark.net>#1/1

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! Received on Thu Nov 16 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Louise Miller: "Wish they all could be California...."
Previous message: Steinar Gravdal: "Splitting this newsgroup ?"
Next in thread: Scott Urman: "Re: Dynamic SQL in Stored Procedures"
Reply: Ron Reidy: "Re: Dynamic SQL in Stored Procedures"
Reply: Karl Brandner: "Re: Dynamic SQL in Stored Procedures"
Reply: Bob King: "Re: Dynamic SQL in Stored Procedures"
Reply: Scott Urman: "Re: Dynamic SQL in Stored Procedures"

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

Original text of this message