Dynamically Calling Procedures

From: Main <kevind_at_i-link.net>
Date: Fri, 28 Aug 1998 10:50:41 -0600
Message-ID: <6s6nar$g4e$1@supernews.com>

Hi,

Is there a way to dynamically call a stored procedure?

I would like to do something like:

BEGIN
   SELECT procedure_name

     INTO w_proc_name
     FORM Actions

    WHERE condition = w_conditition;

   EXECUTE w_proc_name;

END; I have been playing with DBMS_SQL, but this seems to only let you create queries, and not execute programs.

kd Received on Fri Aug 28 1998 - 11:50:41 CDT