This example returns the PARAMINFO information for each parameter in the JSON document in a row. This returns the name, type, position, and value for each parameter in the parameterized request.
select QueryID, RowNum, ParamJSON.ParamInfo from QryLogParamJSON;
Result:
d
QueryID RowNum ParamJSON.ParamInfo
------------------ ------- -------------------------------------------
307190733539634351 1 [{"Name":"x","Type":"INTEGER","Size":4,"Position":1}]
307190733539634351 2 ?