How to use Stored Procedures with Symfony and Doctrine

Question

I having problems at trying to call a MySQL Stored Procedure with Symfony 1.4 and Doctrine 1.2. What I want to do is the following:

In a module/new after typing all the data in the form, I want to insert one of the values in another table.

I don't know if this can be done with Doctrine without using a stored procedure.

Thanks for your help.

Answer 1

You could use triggers but I'm not sure how advanced they are in MySQL. Triggers wouldn't involve any coding in Doctrine, symfony nor PHP. Just stored procedures.

You can achieve pretty similar effect with Doctrine's record listeners or record hooks.