15.10 - Example: Stored Procedures with JSON Type Parameters - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K
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))
...
;