How to return OUT parameters from stored procedure in Symfony 1.4 using Doctrine

Question

I'm not sure how to properly retrieve the OUT parameters from a stored procedure in symfony using doctrine.

My stored procedure looks like:

PROCEDURE procedure_name (IN val1 NUMERIC(10), ... , OUT out1 NUMERIC(10), OUT out2 NUMERIC(10), OUT out3 NUMERIC(10))

I've tried:

$sql = "CALL procedure_name('$val1', ... , @out1, @out2, @out3)";
$con = Doctrine_Manager::connection();
$statement = $con->prepare($sql);
$statement->execute();
$result = $con->query("SELECT @out1, @out2, @out3")->fetch_object();

But that fails with the error "You must have at least one component specified in your from."

Any ideas?

Kevin Lee · Accepted Answer · 2015-04-09 18:37:16Z

1

Solution:

$sql = "CALL procedure_name('$val1', ... , @out1, @out2, @out3)";
$con = Doctrine_Manager::getInstance()->getCurrentConnection();
$statement = $con->prepare($sql);
$statement->execute();
$statement->closeCursor();
$result = $con->fetchAssoc("SELECT @out1, @out2, @out3");

answered Apr 9, 2015 at 18:37

Kevin Lee

1,19113 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to return OUT parameters from stored procedure in Symfony 1.4 using Doctrine

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related