Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE person(id int, age int);
INSERT INTO person VALUES (1,10);

CREATE TABLE

INSERT 0 1

-- simple solution
CREATE OR REPLACE PROCEDURE my_proc(id int, age int)
  LANGUAGE sql AS
$func$
UPDATE person p SET age = $2 WHERE p.id = $1;
$func$;

CREATE PROCEDURE

CALL my_proc(1, 11);
TABLE person;

CALL

id
age

1
11

SELECT 1

-- proof of concept with all bells and whisltes
CREATE OR REPLACE FUNCTION my_func(id int, age int)
  RETURNS void
  LANGUAGE plpgsql AS
$func$
#variable_conflict use_variable
BEGIN
   UPDATE person p
   SET    age = age
   WHERE  p.id = id;
END
$func$;

CREATE FUNCTION

SELECT my_func(1, 12);
TABLE person;

my_func

SELECT 1

id
age

1
12

SELECT 1