Using temp table in Stored procedure help

[S K]

I am using mysql 5.7.

Here is my stored procedure

CREATE PROCEDURE SP_ExposureByStock()
BEGIN
CREATE TEMPORARY TABLE tempExposure AS
SELECT t.ticker
,cq.companyName
,t.quantity
,cq.price
,cq.price * t.quantity
,cq.price * t.quantity - cb.costBasisPerUnit * t.quantity
FROM transactions t
LEFT JOIN currentQuotes cq
ON t.ticker = cq.ticker
LEFT JOIN costBasis cb
ON t.ticker = cb.ticker AND t.brokerage = cb.brokerage AND t.accountNumb = cb.accountNumb
;
SELECT * FROM tempExposure;
END

I get an error as follows

Error
SQL query: Documentation


CREATE PROCEDURE SP_ExposureByStock()
BEGIN
CREATE TEMPORARY TABLE tempExposure AS
SELECT t.ticker
,cq.companyName
,t.quantity
,cq.price
,cq.price * t.quantity
,cq.price * t.quantity - cb.costBasisPerUnit * t.quantity
FROM transactions t
LEFT JOIN currentQuotes cq
ON t.ticker = cq.ticker
LEFT JOIN costBasis cb
ON t.ticker = cb.ticker AND t.brokerage = cb.brokerage AND t.accountNumb = cb.accountNumb
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 14