15.10 - Stored Procedures with JSON Type Local Variables - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K
You can create a stored procedure containing one or more local variables that are JSON data type. You can use the DEFAULT clause with the declaration of these local variables:
  • DEFAULT NULL
  • DEFAULT value

If you specify DEFAULT value, you can use a JSON constructor expression to initialize the local variable. See About JSON Type Constructor.

You can use the stored procedure semantics, including cursors, to access a particular value, name/value pair, or nested documents structured as objects or arrays. You can use this with the JSON methods and functions that allow JSONPath request syntax for access to specific portions of a JSON instance.