I am running a stored procedure from my form on submit. However, I keep getting the following error:
The active result for the query contains no fields.
Below is what I have tried. Code to execute SP DB::select('EXEC myStored_Procedure');
I have also tried
DB::select('SET NOCOUNT ON; EXEC myStored_Procedure');
But both return the same error. I have also used Set NOCOUNT ON;
within the stored procedure itself, but with the error still occurs.
My SP works fine and my web page works fine separately, but when I call the SP from the web page it always returns this error.
How can I get around this error?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire