mysql prepared statement unable to execute. Getting error 1064 in prepared statement

132 Views Asked by At

Query is retrieving correct result but in Prepared statement getting error "Error Code: 1064. check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO audittrail(BATCHID,IPADDRESS,DATE,LINENAME,ACTION) values (1165' at line 2" Thanks in advance:-)

CREATE DEFINER = 'root'@'localhost'
PROCEDURE new_procedure()
BEGIN

DECLARE stmt text;

SET @stmt = (SELECT CONCAT('START TRANSACTION; \n', GROUP_CONCAT(objdata SEPARATOR ';\n'),';\nCOMMIT; \n DELETE FROM qry_obj_dtl where id in (',GROUP_CONCAT(ID SEPARATOR','),');') AS objData1 FROM qry_obj_dtl);

SELECT @stmt;

PREPARE param_stmt FROM @stmt;

EXECUTE param_stmt;

DEALLOCATE PREPARE param_stmt;
  
END
0

There are 0 best solutions below