SQLSTATE [HY000]: General error: 2053 when I call a Stored Procedure?

0

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.

    
asked by anonymous 07.02.2017 / 18:21

0 answers