I'm going by the book to create my first procedure and MySQL continues to tell me the syntax is wrong.

Here is the script, it is verbatim from my book, A Guide to SQL 9th Edition pg.236. Is my book just wrong, or did I fub somewhere?

Code:
CREATE OR REPLACE PROCEDURE DISP_REP_NAME (I_REP_NUM IN REP.REP_NUM%TYPE) AS
    I_LAST_NAME		REP.LAST_NAME%TYPE;
    I_FIRST_NAME 	REP.FIRST_NAME%TYPE;
    
    BEGIN
    SELECT LAST_NAME, FIRST_NAME
    INTO I_LAST_NAME, I_FIRST_NAME
    FROM REP
    WHERE REP_NUM = I_REP_NUM;
    
    DBMS_OUTPUT.PUT_LINE (RTRIM(I_FIRST_NAME)||' '||RTRIM(I_LAST_NAME));
    
    END;
    /
The Error:
CREATE PROCEDURE DISP_REP_NAME (I_REP_NUM IN REP.REP_NUM%TYPE) AS I_LAST_NAME REP.LAST_NAME%TYPE Error Code: 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 'IN REP.REP_NUM%TYPE) AS I_LAST_NAME REP.LAST_NAME%TYPE' at line 1

Any suggestions?

Thank you