Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> calling procedure names that are pulled from a table

calling procedure names that are pulled from a table

From: please help <slow_at_cable.com>
Date: 2000/07/13
Message-ID: <p0nb5.1405$ol5.3124@newsfeed.slurp.net>#1/1

Hi.

Can someone please point me in the right direction? Using a pl/sql file that will be run with a CRON job, I need to be able to grab records from a 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.

I can do this in Oracle Forms 4.5 by putting together a command string, assigning it to a variable, and then use the following command:

FORMS_DDL('begin '||command_var||'; end');

Is there a similar way to do this in pl/sql outside of forms?

Thanks,

Ron Watson
rwatson_at_kemron-lab<takemeout>.com Received on Thu Jul 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US