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;
Subject
Views
Written By
Posted
Error: Commands out of sync; you can't run this command now
1191
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.