Error: Commands out of sync; you can't run this command now
Posted by: XX CVX
Date: January 27, 2019 11:17AM

CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`(in Cid int,out vv int)
BEGIN
set vv=Cid+1;
select * from test1;
END


res = mysql_real_query(&myCont, "call new_procedure(1,@tt)", strlen("call new_procedure(1,@tt)"));

res = mysql_query(&myCont, "SELECT @tt");


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


How do I do get output @tt first;

Options: ReplyQuote


Subject
Views
Written By
Posted
Error: Commands out of sync; you can't run this command now
1278
January 27, 2019 11:17AM


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.