Error: commands out of sync; you can't run this command now.

Question

Hi
When I run the following code, I get the error mentioned in the title. Whatever the variable I am trying to make using this set of lines, it ends up in this error:

SET @v_emp_no = 0;
CALL emp_info('Aruna', 'Journel', @v_emp_no);
SELECT @v_emp_no;

Any help would be appreciated!

Answer 1

Hi Saeed!
Thanks for reaching out.

Could you please provide the entire code you've executed as text? In this way, we will be able to assist you better. Thank you.

Looking forward to your answer.
Best,
Tsvetelin

Answer 2

Hi Tsvetelin

I figured out what was the problem that led to the previous issue, actually in my last exercise I had forgotten to reset the delimiter. However, after fixing it, I am not still able to get the result and when running the code, I get a warning message which is attached below to this comment. In fact, as you can see, the first and third query are run properly, but the call query leads to the warning message.

Error: commands out of sync; you can't run this command now.

Submit an answer

related questions