Execution of a SPL Procedure
Posted in 1998
Renaud MARTIAL — — source: Informix-list mailing list archive (1991-1998)
Hi I'd like to know if there is a way to execute a SPL Procedure whose name is stored in a character string. (We 're working with IUS 9.12.UC3) The Idea is to have a table containing the operations to process, so the process would be fully dynamic. For example, removing a row from this table would result in removing a fonctionnality of my program. >>> table T_PROC ( Id SERIAL, procname VARCHAR(64) ); Thus, the execution would be: >>> FOREACH select procname into s_proc from t_proc >>> EXECUTE PROCEDURE @procname < or something like this >>> END FOREACH