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 ?