sorted by: recent | see :
popular
Content Tagged routines
Video: External Language Stored Procedures
At the 2008 MySQL User Conference and Expo, Eric Herman and Antony Curtis spoke about "External Language Stored Procedures". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#External_Language_Stored_Procedures
Calling application on the database server from stored procedure or trigger
I do not know enough about the subject to answer this, but I know the folks that read this do.
From: http://mysql.meetup.com/137/boards/view/viewthread?thread=2280640
Hi,
I wonder is there any way to call an application which resides on the database server computer from stored procedure or trigger? Is the language of stored procedures and triggers only restricted by SQL statements and some arithmetic operations?
It is interesting that Oracle and MS SQL Server already have this functionality. In Oracle it is Java stored procedure, in MS SQL Server it is called “extended stored procedure” where you can call C++ routine out of your stored procedure. It is difficult overestimate the convenience of being able to do some processing triggerted by the record insertion event.
In this case the database could be used not only for “pulling” data out, but also being able to “push” data to some component.
You can go to the meetup message boards and post an answer. If you’d like to post anonymously, feel free to use the account:
admin@sheeri.com
and password
guest
Thanx!