Having trouble executing stored procedures in Laravel 4 ?

I faced a lot of problem while figuring out how to execute a stored procedure in Laravel4.
Here’s a simple way to do it :

$res = DB::select(‘call stored_proc_name(“‘.DB::raw($param1).‘”,”‘.DB::raw($param2).‘”)’);