Re: Using temp table in Stored procedure help

[Peter Brawley]

Read the manual about stored routines and delimiters.

DELIMITER go      -- set delimiter for stored routine creation
CREATE PROCEDURE SP_ExposureByStock()
BEGIN
  ... 
END;              -- terminating semicolon was missing
go                -- delimiter tells mysql proc code ends here
DELIMITER ;       -- restore standard interactive delimiter