MySQL procedure error - You have an error in your SQL syntax;

Question

I have an error when I want to run in MySQL phpmyadmin this procedure.

  DELIMITER //
create or replace procedure proc_ex_3a(in v_adr varchar)
BEGIN
    select * from Furnizori WHERE v_adr LIKE '%8' order by v_adr;
END //
DELIMITER ;

The syntax should be fine, but this error occurs

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') BEGIN select numef from Furnizori WHERE v_adr LIKE '%8' order by v_adr; ...' at line 1

Answer 1

等待大神答复