SQL Procedures Using JSON Type Example | VantageCloud Lake - Example: Stored Procedures with JSON Type Parameters - Teradata Vantage

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))
...
;