Hello !
i have an error on my db query, i try to call a sql procedure, but DB::query('CALL getLists(27);')->execute(); return just the count of the result.. !
If i try a normal query, like select, print_r return a normal response. And my procedure works fine in phpmyadmin.
Where is the mistake?
Different types of queries are handled by different DB drivers, based on the type of query. But there is no driver for queries of type "CALL". So you have to force the query to be handled by the "SELECT" driver by specifying the driver in the call.