Error Code: 1615 Prepared statement needs to be re-prepared

[Amritansh Rastogi]

While executing the following code in MySql procedure I get the following error.
In actual code V_QUERY is being set dynamically.

"Error Code: 1615 Prepared statement needs to be re-prepared"

--------------------------------------------------------------------------------

SET V_QUERY = 'SELECT SNAG_NUMBER INTO @V1 FROM crm_snag_wf_vw WHERE WF_INPROCESS_DTL_ID=68';

SET @V_QUERY1 = V_QUERY;
PREPARE STMT1 FROM @V_QUERY1;
EXECUTE STMT1;
DEALLOCATE PREPARE STMT1;
SET V_SUB = REPLACE(V_SUB,V_TAG_NAME,@V1);

--------------------------------------------------------------------------------

The above code runs fine on Windows installation of Mysql but with linux installation it gives the above error.

Linux Details:

LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Distributor ID: CentOS
Description: CentOS release 6.7 (Final)
Release: 6.7
Codename: Final


Please help.

Regards
Amritansh