The following statement defines a stored procedure with an IN parameter that is a JSON type with a maximum length of 100.
CREATE PROCEDURE my_tdsp1 (IN p1 JSON(100)) ... ;
The following statement defines a stored procedure with an OUT parameter that is a JSON type with a maximum length of 100.
REPLACE PROCEDURE my_tdsp2 (IN p1 INTEGER, OUT p2 JSON(100)) ... ;