MySQL Forums
Forum List  »  Perl

Re: Stored Procedure Calling a Perl program
Posted by: Bill Karwin
Date: June 07, 2006 03:17PM

I recommend against launching processes from stored procedures or triggers. It can be detrimental to performance, stability, and security in the MySQL Server.

There's also no syntax for it in the stored procedure language, so you'd have to something tricky in a UDF.

This kind of operation is much better to launch from your application, but you could design logic in the stored procedure to modify a flag in the form of a value in a database table for this purpose. Your app would watch for changes to that value periodically, and then run the Perl process, and clear the value in the flag column.

Regards,
Bill K.

Options: ReplyQuote


Subject
Written By
Posted
Re: Stored Procedure Calling a Perl program
June 07, 2006 03:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.