Oracle 21c JSON datatype

[jdorlon]

Hello,

In this post viewtopic.php?f=5&t=44289 I mentioned that a customer was receiving an error with the JSON datatype under 21c. To give an update on that, I have just downloaded 21c from Oracle and I don't get any error. So maybe the problem was only with 20c.

However, in 21c, with ODAC, when looking at the TFieldDesc for a JSON column, it looks exactly like a BLOB column. Am I missing anything? If not, can you make a new SubDataType value for JSON columns? I need to be able to distinguish JSON from ordinary BLOB datatypes.

Thank you

John Dorlon

[MaximG]

Hi John!

Thank you for your request!
Please note that we just started to explore the use of JSON fields introduced in Oracle 21c.

[jdorlon]

If you could come up with a way to provide it as CLOB, that would be ideal. Then we'd be able to edit the data in a smartquery result.

[MaximG]

Hi John! Thank you for your reply! We took into account your suggestion and will try to implement work with JSON fields in the most convenient way !