Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check accuracy of JSON string

LauryMar 12 2018 — edited Mar 16 2018

Hi,

A JSON string can be defined as varchar2, clob for instance.

Does someone know how to check if a given JSON is valid or not before any insertion to a table, or before processing it "on the fly", with pre-insertion?

I didn't find such a function.

It applied to Oracle RDBMS 12.1 and 12.2.

Thanks by advance for any tip.

Kind Regards

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 13 2018
Added on Mar 12 2018
16 comments
2,459 views