Subject Re: [firebird-support] Re: calling an sp indirectly
Author Dimitry Sibiryakov
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:

OUT tmp.sql;
select 'EXECUTE PROCEDURE '||proc_name||';' from your_table;
INPUT tmp.sql;

SY, Dimitry Sibiryakov.