MySQL Forums
Forum List  »  MySQL Workbench

Commands out of sync
Posted by: David Berg
Date: June 27, 2016 12:00PM

I'm running Workbench 6.3.6 against MySQL 5.7.x on Windows 7. Executing a stored procedure I've executed hundreds of times before, but perhaps last before I upgraded to this particular MySQL configuration. All opened cursors are closed within each section.

The basic premise of the procedure is ...

Part1: BEGIN
Abc: WHILE condition DO
Def: WHILE condition DO ...
END WHILE Def;
END WHILE Abc;
END Part 1;

Part2: BEGIN
...
END Part2;
END $$


I'm repeatedly getting the error "2014: Commands out of sync; you can't run this command now."

Based on what the procedure accomplished and what it didn't, I can guess the statement it hung up on. But I don't know why or what to do about it.

Suggestions will be appreciated. Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Commands out of sync
1321
June 27, 2016 12:00PM
440
June 27, 2016 12:32PM
479
June 27, 2016 03:00PM
457
June 29, 2016 04:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.