calling procedure names that are pulled from a table

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