I am trying to write a script that creates and calls a stored procedure named spInsertNewCategory
and getting this error on the following code:
CREATE PROCEDURE spInsertCategory(category_name VARCHAR(50))
BEGIN
INSERT INTO Categories
VALUES (@CategoryName);
END