You can create stored SQL procedures that contain one or more JSON data type parameters. IN, OUT, and INOUT parameters can be JSON types.
You can also create stored SQL procedures that contain one or more local variables that are JSON data types. 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.
You can use the stored procedure semantics, including cursors, to access a 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.