| Subject | Re: [firebird-support] Execute linux command from stored proc or trigger |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2003-09-16T20:05:29Z |
At 9/16/2003 02:13 PM (Tuesday), xongabilly wrote:
event triggered when an insert or update to the table is performed. You
would then have a separate daemon running on the server which having
registered interest in such events performs any outside tasks which are
required. This uses triggers and events appropriately, does not abuse the
UDF mechanism, and does not require Firebird to handle shell access itself.
>Can I execute a linux/unix command from a stored procedure orI think the most successful, long term solution would be to have a Firebird
>trigger? I want create a linux user after insert on my app_user_table.
>I know it's possible to write a UDF, but I'm looking for something
>like "host" command from Oracle.
event triggered when an insert or update to the table is performed. You
would then have a separate daemon running on the server which having
registered interest in such events performs any outside tasks which are
required. This uses triggers and events appropriately, does not abuse the
UDF mechanism, and does not require Firebird to handle shell access itself.