Skip to Main Content

Validating JSON in the database

hsemarJul 31 2018 — edited Aug 1 2018

Hi,

I'm using PLSQL and trying take the input parameter as JSON.   Is there a way to validate the provided string is json or not.  Once validated i have to use the json fields.

I'm looking for various functions like treat ..etc.,  But i'm not succeeded in using for validating.

The database version is 12cR2.

Thank you.

Regards,

Ramesh G

This post has been answered by odie_63 on Aug 1 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Aug 29 2018
Added on Jul 31 2018
4 comments
829 views