Home -> Usenet -> comp.databases.oracle -> Re: Dynamic PL/SQL and Stored Procedures

Re: Dynamic PL/SQL and Stored Procedures

From: Gerard H. Pille <ghp_at_infosoft.be>
Date: 1996/03/26
Message-ID: <4j9e05$if1_at_news.Belgium.EU.net>#1/1 







In article <31579DF9.3817_at_mcimail.com>, Ernie Svehla 
(esvehla_at_mcimail.com) says...


!>

!>Hi Everyone,


!>

!>I am trying to find out how I can dynamically invoke a stored procedure 

!>through the use of the DBMS_SQL package. Does anyone have any example 

!code or 

!>suggestions? Looking in the Steven Feuerstein text I only found 

!discussion on 

!>how to execute inserts, updates, selects, etc.

!>

!>Thanks in advance!

!>

!>Ernie Svehla




I don't know the 'Steven Feuerstein text', but I suppose that if you take 
one of his examples and replace the 'select ...' by an 
'execute proc_whatever(param_this, param_that);'
you should be OK. No?


-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard


Received on Tue Mar 26 1996 - 00:00:00 CET












Original text of this message