Re: Syntax Error

[Peter Brawley]

Quote

If i add the delimiter is creates the procedure with a message that says it had errors.

This compiles without error in 5.6:

delimiter go
CREATE PROCEDURE Delete_BillOfMaterialsDetail (
  IN InOrderDate DATE, 
  IN InProductCode varchar(40), 
  IN InRawMaterialProductCode varchar(40) 
) 
BEGIN 
IF EXISTS (
  SELECT * 
  FROM basf_rawmaterialplanning.BillOfMaterialsDetail 
  WHERE OrderDate = InOrderDate 
    and ProductCode = InProductCode 
    and RawMaterialProductCode = InRawMaterialProductCode
) THEN 
  DELETE FROM basf_rawmaterialplanning.BillOfMaterialsDetail 
  WHERE OrderDate = InOrderDate 
    AND ProductCode = InProductCode 
    AND RawMaterialProductCode = InRawMaterialProductCode; 
END IF; 
END; 
go
delimiter ;

Quote

I also recieve an error trying to declare a variable:
DECLARE @myvar INT;

Indeed. User variables (vars whose names begin with '@') cannot be declared. Lose the '@'.

Consider reading the manual page for CREATE STORED PROCEDURE.