Works on both clients.
SELECT JSON_OBJECT('ID' value id, 'Producto' value nombre format json) AS json_data_new
FROM Producto p;
Yes, I know, but I was doing a presentation on Groundbreakers Tour in Argentina regarding the new enhancements in Oracle 19c for JSON... and the idea was to show that the KEY and VALUE keywords are not required anymore .
It must be something related to the thin driver or the IDE... strange
1 person found this helpful
As soon as I downloaded SQL Developer 19.2, I also downloaded Oracle Instant Client 19.3 (even though, so far, I only access 11g, 12c, and 18c DB's).
Running your test case against 11g, 12c, and 18c with Oracle Instant Client 18.3 all result in the same error message you show in your post. However, if I switch to Oracle Instant Client 19.3 (and Use OCI/Thick driver preference in Database -> Advanced), then I see...
SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis"
SQL Error: ORA-02000: missing VALUE keyword 02000. 00000 - "missing %s keyword"
Perhaps if I download the latest VM with Oracle 19.3 the test case would work? I am downloading that now and will post back when I know.
we're still shipping the 18c jdbc driver, if this is new to 19c, you'll need to use a thick connection with a 19c instant client
Perfect, that's the reason!!!
I wondered what the problem was and imagined that was something related with the JDBC driver, but I was 100% focused on finishing the demo and the examples and did not investigate it...then today I saw the same error on another post, completely unrelated (the poster was using SQL Developer 1.5) and remembered the issue and though that this would be the best place to ask!
Thanks Jeff for the info.