Re: calling procedure names that are pulled from a table

From: RonR <ronr_at_my-deja.com>
Date: 2000/07/14
Message-ID: <01HW.B594B42B00013E2511039270@news.planet.nl>#1/1

On Thu, 13 Jul 2000 19:34:49 +0200, please help wrote (in message <p0nb5.1405$ol5.3124_at_newsfeed.slurp.net>):
> table that will contain package.procedures and some parameters for each, and
> then have the pl/sql file do a call to each procedure and pass in the
> parameters.
>
> assigning it to a variable, and then use the following command:
>
> FORMS_DDL('begin '||command_var||'; end');
>
> Ron Watson

Hi Ron,

you could use DBMS_SQL to call procedures in a dynamic way like you do with FORMS_DDL. check it out.

have luck,

-- 
Ronald.    <  \_ _                     o o
                       | o  \     %-/\//_\\/\-%             
                       '(*)-'---(*)       (*)       
home: http://home.wxs.nl/~ronr/RonR.html
PGP :  http://home.wxs.nl/~ronr/ronr_pgp.key
 The best way to accelerate a computer 'running' windows is by gravitation.

Received on Fri Jul 14 2000 - 00:00:00 CDT