I need a stored procedure where I can execute multiple delete from statements.
This will work to create a stored procedure, but when I add in other delete from, get error invalid sql statements when try to create
CREATE PROCEDURE DeleteSpecimenTwo
(IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;
END;
This doesn't work
CREATE PROCEDURE DeleteSpecimenTwo
(IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;
DELETE FROM PSPEC WHERE PSPECNO = :Specno;
END;