MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `TestTable` (
  `id1` smallint(5) unsigned NOT NULL,
  `id2` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `text1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `text2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  UNIQUE KEY `uq_TestTable_id1_id2` (`id1`,`id2`),
  KEY `ix_TestTable_id1_id2` (`id1`,`id2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE PROCEDURE `proc_test`(
    IN in_id1 smallint unsigned,
    IN in_id2 nvarchar(10),
    OUT outtext1 nvarchar(20),
    OUT outtext2 nvarchar(10)
    )
BEGIN

    SET outtext1 = '';
    SET outtext2 = '';

    SELECT
        `text1`, `text2`
        INTO outtext1, outtext2
    FROM  `TestTable`
    WHERE
        `id1` = in_id1 AND 
        `id2` = in_id2
    LIMIT 1;

END
INSERT INTO `TestTable`
(`id1`, `id2`, `text1`, `text2`)
VALUES
(1, 'id2', 'this is text1', 'i am text2')
call proc_test(1, 'id2', @outtext1, @outtext2);
select @outtext1, @outtext2;


@outtext1
@outtext2


this is text1
i am text2


call proc_test(1, 'xxx', @outtext1, @outtext2);
select @outtext1, @outtext2;


@outtext1
@outtext2






call proc_test(9, 'id2', @outtext1, @outtext2);
select @outtext1, @outtext2;


@outtext1
@outtext2






SELECT `text1`, `text2`
FROM  `TestTable`
WHERE `id1` = 1 AND `id2` = 'id2';


text1
text2


this is text1
i am text2


SELECT `text1`, `text2`
FROM  `TestTable`
WHERE `id1` = 1 AND `id2` = 'xxx';
SELECT `text1`, `text2`
FROM  `TestTable`
WHERE `id1` = 9 AND `id2` = 'id2';