I am using Laravel
4.2 and am calling a Stored Procedure
from a database on the server. Locally it works fine, but on the server, using the same DB, it gives error.
The call is as follows:
$result = DB::select('CALL sp_precos_especiais("'.$codigocliente.'",
"'.$codigoartigo.'", "'.$quantidade.'",
"'.$grupo_produto.'", "'.$FirmCode.'")');
When running a listing, on the server, it works except on two articles, giving the following error:
Caught exception: SQLSTATE [HY000]: General error: 2053 (SQL: CALL sp_precos_especiais ("C000000", "445706049", "1", "146", "75"
I've already checked the PHP
versions, and I'm using 5.6 on both sites. Can it be any special configuration? The Bank is the same, the place to call Stored Procedure
, is that it is different.