Last answered:

21 Jul 2022

Posted on:

18 Jul 2022

0

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

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!

2 answers ( 0 marked as helpful)
Instructor
Posted on:

19 Jul 2022

0

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

Posted on:

21 Jul 2022

0

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.image

Submit an answer