On 5 Jan 2006 at 20:39, Marcelo wrote:

>> you could do it on the client side.
>
>I want to avoid this approach completely, as Oracle WF does, the only
>client app that I would allow is isql (with an sp argument) attached
>to cron.

At Firebird Conference Paul Reeves gave a nice talk about advanced
using of isql. Try to find it somewhere.
A little trick: you can select your sps names making a script from
them and then execute it immediatelly. Something like this:

SET HEADING OFF;
OUT tmp.sql;
select 'EXECUTE PROCEDURE '||proc_name||';' from your_table;
OUT;
INPUT tmp.sql;
COMMIT;

--
SY, Dimitry Sibiryakov.