MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
drop table if exists document_line;
-- SMALLINT: 0 to 65535 || -32768 to 32767
CREATE TABLE document_line (account_id SMALLINT , value decimal(7, 2));
INSERT INTO document_line VALUES
  (1, '123.45'),
  (212, '345.88989'),
  (322, 789.234),
  (4345, 334.78956);

select * from document_line;

Records: 4  Duplicates: 0  Warnings: 3




account_id
value


1
123.45

212
345.89

322
789.23

4345
334.79


-- MySQL Function
-- DELIMITER //
CREATE FUNCTION get_test(
    _account_id SMALLINT UNSIGNED
)
RETURNS SMALLINT UNSIGNED
DETERMINISTIC
BEGIN
    RETURN _account_id;
END;
-- // DELIMITER ;
-- Stored Procedure
-- DELIMITER //
CREATE PROCEDURE check_post_document()
BEGIN
    SELECT
        get_test(dl.account_id),
        dl.account_id 
    FROM document_line dl;
END;
-- // DELIMITER ;
call check_post_document();


get_test(dl.account_id)
account_id


1
1

212
212

322
322

4345
4345