title: Cant able to export mysql data to godaddy server - showing syntax error
body: <p>This is my procedure:</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `RPTtempreceipts`(
  IN vRCPTNO VARCHAR(20))
  BEGIN
  DECLARE vBNo VARCHAR(20);
  DECLARE vPtyCde INTEGER DEFAULT 0;
  DECLARE vWMC VARCHAR(20);
  DECLARE vPrdCde VARCHAR(10);
  DECLARE vBcde CHAR(5);
  DECLARE vSAPLID INTEGER DEFAULT 0;
  
  -- Assign Values
  SELECT T.BNo,T.pty_code,T.WMC,T.PrdCde,T.Bcde INTO 
  vBNo,vPtyCde,vWMC,vPrdCde,vBcde FROM
  tbltransaction T INNER JOIN tbltransreceipts TR
  ON T.BNo=TR.BNo WHERE TR.RcptNO=vRCPTNO;
  
  SELECT SAPLID INTO vSAPLID FROM tblcust_prd_wor WHERE pty_code=vPtyCde;
  
  -- Select Queries are configured as for Typed Dataset under DT's
  SELECT * FROM tbltrans WHERE BNo=vBNo;
  SELECT * FROM tbltransrcpt WHERE RNo=vRCPTNO;
  END
  </code></pre>
  
  <p>Showing following error:</p>
  
  <blockquote>
    <p>Error Code : 1064 You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right
    syntax to use near 'DECLARE vPtyCde INTEGER' at line 1 (328 ms taken)</p>
    
    <p>Error Code : 1064 You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right
    syntax to use near 'DECLARE vWMC VARCHAR(20)' at line 1 (312 ms taken)</p>
    
    <p>Error Code : 1064 You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right
    syntax to use near 'DECLARE vPrdCde VARCHAR(10)' at line 1 (328 ms
    taken)</p>
    
    <p>Error Code : 1064 You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right
    syntax to use near 'DECLARE vBcde CHAR(5)' at line 1 (313 ms taken)</p>
    
    <p>Error Code : 1064 You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right
    syntax to use near 'DECLARE vSAPLID INTEGER DEFAULT 0' at line 1 (297
    ms taken)</p>
    
    <p>Error Code : 1327 Undeclared variable: vBNo (312 ms taken)</p>
    
    <p>Error Code : 1327 Undeclared variable: vSAPLID (297 ms taken)</p>
  </blockquote>
  
  <p>I am confused with this because its working fine in localhost.
  now i finished the project and like to upload the db to server.
  But these errors stopped me to proceed further... Please help me.</p>
  
  <p>Regards,
  Sensa.</p>