See EXECUTE STATEMENT.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Marcelo
> Sent: Thursday, January 05, 2006 8:59 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] calling an sp indirectly
>
> Hi!
> Can I invoke an sp indirectly say, using its name, retrieved
> from a table from inside another sp?
> Ill explain what I want to do:
> I have a user table with a nested table of sp names which the
> user wants to be invoked on a timely basis. There would be an
> sp which would be invoked, say, every hour that would scan
> each user list of sps and fire them.
> In case you ask yourself what Im doing, it is a workflow
> system, and the sps which are suscribed by each user are
> various reports chosen from the db procedure table. These
> procedures send a mail to the user with the report (using FireUDFLib).
> Thanks, Marcelo.
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>

[Non-text portions of this message have been removed]