First add DB library to controller, with use DB;

Use bindings instead select for parameters :

 DB::select('SELECT * FROM stored_procedure(?,?)', ['param1', 'param2']);

Now the return is array object. No need get() for result.