Re: Dynamic SQL in Stored Procedures

From: Ron Reidy <rreidy>
Date: 1995/11/17
Message-ID: <48i8ka$q6c_at_peacock.tcinc.com>#1/1

costello_at_clark.net (Matthew C. Costello) wrote:
>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!
>
Look at the 'dbms_sql' package.

rr Received on Fri Nov 17 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Karl Brandner: "Re: Dynamic SQL in Stored Procedures"
Previous message: Issac Wong Tuck Kwong: "Replication Option"
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: Karl Brandner: "Re: Dynamic SQL in Stored Procedures"
Reply: Andrew Zitelli: "Re: Dynamic SQL in Stored Procedures"

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

Original text of this message