MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();


VERSION()


10.3.15-MariaDB-1:10.3.15+maria~stretch-log


DROP TABLE IF EXISTS `test`;
CREATE TABLE IF NOT EXISTS `test` (
  `contador` BIGINT UNSIGNED
) SELECT 1000 `contador`;
DROP PROCEDURE IF EXISTS `obtener_ultimo_registro`;
CREATE PROCEDURE `obtener_ultimo_registro` (
  IN `tabl` VARCHAR(64) CHARSET utf8,
  IN `campo` INT
) 
NOT DETERMINISTIC
NO SQL
SQL SECURITY DEFINER
SELECT *
FROM `tabl`
ORDER BY `campo` DESC
LIMIT 1;
-- CALL `obtener_ultimo_registro`('test', 'contador'); -- ERROR
DROP PROCEDURE IF EXISTS `obtener_ultimo_registro`;
CREATE PROCEDURE `obtener_ultimo_registro` (
  IN `tabl` VARCHAR(64) CHARSET utf8,
  IN `campo` INT
) 
NOT DETERMINISTIC
NO SQL
SQL SECURITY DEFINER
EXECUTE IMMEDIATE
  CONCAT('SELECT * 
          FROM `', `tabl`, '` 
          ORDER BY ', `campo`, ' DESC 
          LIMIT 1');
CALL `obtener_ultimo_registro`('test', 1);


contador


1000


DROP PROCEDURE IF EXISTS `obtener_ultimo_registro`;
CREATE PROCEDURE `obtener_ultimo_registro` (
  IN `tabl` VARCHAR(64) CHARSET utf8,
  IN `campo` INT
) 
NOT DETERMINISTIC
NO SQL
SQL SECURITY DEFINER
BEGIN
  SET @`sql` := CONCAT('SELECT * 
                        FROM `', `tabl`, '` 
                        ORDER BY ', `campo`, ' DESC 
                        LIMIT 1');
  PREPARE `stmt` FROM @`sql`;
  EXECUTE `stmt`;
  DEALLOCATE PREPARE `stmt`;
END;
CALL `obtener_ultimo_registro`('test', 1);


contador


1000