It's possible to use Stored Procedure with MSSQL?

markoax21 · December 7, 2023, 4:06pm

I’m trying a stored procedure like that, with a custom query? (MSSQL)
Am I wrong? it’s possible do that?

markoax21 · December 12, 2023, 6:56am

any Ideas for me? thanks to everybody

patrick · December 12, 2023, 10:16am

Did you define the parameters with the same names?

markoax21 · December 12, 2023, 1:04pm

Yes, of course
yes

patrick · December 12, 2023, 2:07pm

Is @p0 perhaps a parameter used within the Stored Procedure. The call looks correct, perhaps the Stored Procedure returned the error due to incorrect parameter values.

umadmin · December 13, 2023, 5:09am

I’m calling a stored procedure successfully in my app - the only syntax difference I see is that I don’t have a space between the procedure name and the open parenthesis:

CALL bracket_generator(:P1)

It would be silly, but worth a quick test.

markoax21 · December 13, 2023, 8:17am

thank you @umadmin, but the problem remains even without space.

markoax21 · December 15, 2023, 10:17am

I did some experiments. If I use the syntax “EXEC” I can write in the table.
But doing “execute query” it seems that the procedure does not end (if I check the table, the data has been written)

How can see where is the problem? From the browser console I do not seem to see anything abnormal