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
Oracle 21c JSON datatype
Re: Oracle 21c JSON datatype
Hi John!
Thank you for your request!
Please note that we just started to explore the use of JSON fields introduced in Oracle 21c.
Thank you for your request!
Please note that we just started to explore the use of JSON fields introduced in Oracle 21c.
Re: Oracle 21c JSON datatype
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.
Re: Oracle 21c JSON datatype
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 !