MySQL Forums
Forum List  »  Stored Procedures

Error Code: 1615 Prepared statement needs to be re-prepared
Posted by: Amritansh Rastogi
Date: February 27, 2016 05:33AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Error Code: 1615 Prepared statement needs to be re-prepared
7316
February 27, 2016 05:33AM


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.