Query not executing after running stored procedure

nkthakur · April 22, 2016, 10:52am

Steps are as follow
Step1 - Execute some query
Step2 - call stored procedure which returns data
Step3 - Depending on data execute query which update status in database

Issue is now that after step2 executed step3 never execute. Can somebody help me what settings required to execute queries after stored procedure call.

Topic		Replies	Views
what's the execution order of each part of a sql query Other MySQL® Questions	0	361	February 20, 2019
Real Performance of Stored Procedure Testing Other MySQL® Questions	1	655	November 30, 2009
Why only a single query is executed on commit? Other MySQL® Questions	2	401	July 14, 2008
MySQL stored procedures - execution time varies significantly from run to run Other MySQL® Questions	1	884	November 14, 2017
mysql going to sleep/sbwait while executing slow query Other MySQL® Questions	7	1346	December 20, 2006

Query not executing after running stored procedure

Related topics