Example: Stored Procedures with JSON Type Parameters

Teradata Vantageā„¢ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
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))
...
;