Execute Mysql Stored Procedure In Yii Applications.

$connection = Yii::app()->db;

     	$command = $connection->createCommand("CALL sp_generate_payroll('$doc_date',$hrid,$clientid)");


     	$command->execute();

This statement will execute MySQL stored procedure by YII application. Tested successfully.