lundi 24 octobre 2016

Issue in calling a Stored Procedure in Laravel

I'am calling a MySQL stored procedure using laravel as below,

$items = DB::select(
        'call sp_name(?, ?, ?)',
        array(
            $param1, $param2, $param3
        )
    );

this worked perfectly until today.

ISSUE

When we call route related to this Store procedure call, page keeps loading nothings happens, But at the same time if we log in to MySQL and do a manual call to Store procedure using a query as CALL sp_name($param1, $param2, $param3); went successful.

Can someone please explain why Store procedure fails when the calling happens through Laravel?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire