I am receiving this error when attempting to run in MYSQL.. I believe that I may be calling variables wrong.. please help

adb.sql X SQL Worksheet History 0.035 seconds Worksheet Query Builder 1 E Create or replace procedure concatenate_strings2 2prodid INT, product_name OUT Varchar2) 3Is 4 5 Begin 6 Select productname into product name fron producttable 7where prodid-producttable.productid; 8 dbms_output. put_line( 'The Product name for product ID: prodid 'is' I product _name): 9 dbms-output.put-line ("Date : ' II SYSDATE Il "user:' SYS. CONTEXT ("USERENT','0S-USER')); 10 EXCEPTION 11 WHEN NO DATA FOUND THEN 12 dbms_output. put_linef 'The result did not have any information'); 13ERD 14/ 15Execute concatenate_strings2 (302j; 16 Script Output x 4| Task completed in 0.035 seconds he Cause:Usually a PL/SQL compilation error. *Action: PROCEDURE CONCATENATE_STRINGS2 compiled Error starting at line 15 in command: Execute concatenate_strings2 (302) Eror report: ORA-06550: line l, column 7: PLS-00306: wrong number or types of arguments in cal1 to 'CONCATENATE_STRINGS2' ORA-06550: line l, column 7: PL/SQL: Statement igmored 06550. 00000- "line %s, column %s: %s" *Cause: Usually a PL/SQL compilation error. *Action