0

I am looking for the schema validation for JSON structure received during the API Invocation from ORDS. Lets say I have 10 different json tags constructing the JSON and I want to validate this JSON against pre-defined validation to check if any required parameters are missing or to validate the datatype.

I am looking for the functionality similar to XLST which is used for XML schema validation.

Please note this schema validation is required for the JSON using PL/SQL and ORDS(Oracle Rest Database Services).

Technical Components: SQL, PL/SQL, ORDS. We want something which is compatible with the mentioned components.

Sushil
  • 1
  • 1
  • Possible duplicate of [XSLT equivalent for JSON](https://stackoverflow.com/questions/1618038/xslt-equivalent-for-json) – Eel Lee Mar 27 '19 at 14:21
  • Hello Sushil. Firstly, I think your question has already been answered here https://stackoverflow.com/questions/1618038/xslt-equivalent-for-json And secondly, why would you tag this question with plsql, oracle12c and plsqldeveloper? – Eel Lee Mar 27 '19 at 14:22
  • Hello Lee, This is tagged in pl/sql and oracle because I am looking to code using pl/sql. The objective is to have a JSON schema validation for the JSON generated using SQL and PL/SQL. – Sushil Mar 28 '19 at 04:19

0 Answers0