Re: Is there any way i can call an external program like C/Java using stored procedures or trigger?

[Roland Bouman]

You can write an UDF, and call that from inside the trigger. The UDF would contain the code to communicate with your application. Of course, you cannot target a specific client from there. Inside the UDF, there's no context what client caused the trigger to fire.

see: http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html

It's brief and shallow, but maybe this will get you started:

http://rpbouman.blogspot.com/2005/11/using-udf-to-raise-errors-from-inside.html

BTW, what do you want to achieve exactly?




Edited 1 time(s). Last edit at 01/04/2006 09:06PM by Roland Bouman.