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

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty
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))
...
;