Page 1 of 1

Oracle 12.2 + latest dbForge 4.0.304 / JSON_TABLE problem

Posted: Sun 17 Mar 2019 12:32
by Yahia
Hi,

any statement with JSON_TABLE in it leads to Oracle errors (when trying to execute with F8) and/or the formatter claiming a syntax problem.
The same statement (copy/paste) works without any problem from SQLPLUS .
It does not make a difference whether the statement is simple or complex - it happens always... for example:

SELECT * FROM JSON_TABLE('[[]]','$[*]' COLUMNS X PATH '$');

How can I solve this?

Best Regards
Yahia

Re: Oracle 12.2 + latest dbForge 4.0.304 / JSON_TABLE problem

Posted: Wed 20 Mar 2019 09:14
by alexa
We will fix this issue in one of the next product builds and will notify you once it's available for downloading.