Comments by Member 10895951 (Top 1 by date)

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`(_action varchar(10) ,abc varchar(100))
BEGIN
if _action = 'INSERT' then
insert into tab_file (File) values (abc);
end if;
if _action = 'select' then
select ID,File from tab_file;
end if;
END


Change your parameter and column value as abc instead of the column name .
becuase your select command is getting the parameter values.