error in creating stored procedure using heidiSQL

Question

I am trying to write a stored procedure using Heidi sql. I am getting below error. I tested the query and it returns right result, but in Heidi sql, I keep getting below error:

Below is my query and the screen shot from heidiSQL:

DELIMITER //
BEGIN
  SELECT 
  VitalID,
  firstName,
  MiddleName,
  LastName,
  Address,
  Zip,
  City,
  State,
  updatedOn,
  StatusCode
  FROM personalrecord 
END
//

DELIMITER ;

Put the `DELIMITER //` before `CREATE PROCEDURE` – Akhilesh Mishra May 24 '20 at 19:24 — Akhilesh Mishra, May 24 '20 at 19:24

score 1 · Accepted Answer · answered May 24 '20 at 19:43

Your Create procedure statementshould be like

DELIMITER //
CREATE PROCEDURE index_AllPersonRecordGet()
LANGUAGE SQL
NOT DETERMINISTIC 
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
  SELECT 
  VitalID,
  firstName,
  MiddleName,
  LastName,
  Address,
  Zip,
  City,
  State,
  updatedOn,
  StatusCode
  FROM personalrecord;
END
//

DELIMITER ;

error in creating stored procedure using heidiSQL

1 Answers1