Re: Dynamic SQL in Stored Procedures
From: Bob King <rking_at_dfw.net>
Date: 1995/11/18
Message-ID: <48kcme$cm8_at_fnord.dfw.net>#1/1
Date: 1995/11/18
Message-ID: <48kcme$cm8_at_fnord.dfw.net>#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.
try dbms_sql. I haven't tried it on NT, but it certainly works on VMS
7.1.3 We are using it to do all sorts of things, in particular move
accounts (we are replacing all the OPS$ accounts).
>Thanks!
Bob King
Business Phone - (817) 551-8223
** all comments are personal and do not necessarily
the views of my employer, wife, daughter or dog (a pug) :-) Received on Sat Nov 18 1995 - 00:00:00 CET