Does anyone know, or is it possible to call and external program from a
trigger or stored procedure.

I need to run a baby program based in Java on a Linux machine from a
trigger or stored procedure.

I do not need to pass anything to it, I just need to tell it when to run.

Is this possible?  If so could someone enlighten me as to how, or point
me in the direction of documentation that covers this.  I have looked
through the manuals but have not come across anything yet.

Please help, I need this functionality for a current project.  Not sure
about alternative options at the moment. Hopefully I will not have to
look for one.

Thanks. :)

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone/fax 707.766.9509
http://www.obsidian-studios.com

I would create a udf for this purpose.

Igor

"O-S Inc. Support" <supp...@obsidian-studios.com> wrote in message
news:3B8E9202.1010300@obsidian-studios.com...

What you want is start another proccess (JRE). I'm not quite shure the
security problem you can get since it will run, I guess, with the same
privileges as the IB process. Also, it should be some kind of IPC because if
the UDF allways start the process you can get as many of that child process
as the times the UDF is called.

--
Sergio Samayoa
Lgica Software
http://www.geocities.com/logicasw/

Igor,

Thanks, the UDF concept has pointed me in the right direction. I have
found the proper documentation and am well on my way.

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone/fax 707.766.9509
http://www.obsidian-studios.com

Sergio,
        Thanks, the UDF concept has pointed me in the right direction.  I have
found the proper documentation and am well on my way.

I do not think I will run into any security issues, since once the baby
program is called, its only mission is to send a email. But I will keep
that in mind and will use precaution.

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone/fax 707.766.9509
http://www.obsidian-studios.com

Hi All,
  An alternative method would be to create a app that runs on the server
which connects to the database and listens for interbase events (I've
never used them!). This would have the advantage that the start-up time
would be minimal.

Regards
  Ian Newby