Hi,
I am using SQL-Developer (20.4.1.407) on Windows Server 2016 (ver. 1607) connecting to Oracle 19c Standard Edition 2.
I am using SQL-Developer to create some JSON files from my query results and I am seeing two odd things which I wonder if others can replicate.
For the purposes of testing this problem, my query output is a single column of VARCHAR2(128) containing the same value, "XYZ" in each row.
I am exporting the query results by right-mouse clicking in the query [Query Result] and selecting Export... to invoke the Export Wizard
Using Export Format=json
If my output is up to and including 49 rows the resultant json file is perfectly formed and can be used elsewhere. If the output is 50 rows or more, the resultant json file is malformed in that the RESULTS portion (the column headers of the output) is mostly missing, whereas the ITEMS portion (the actual data) is complete whether it be 50, 500 or 5000 rows.
Using Export Format=json-formatted
If my output is up to and including 49 rows the resultant json-formatted file is perfectly formed and can be used elsewhere. If the output is 50 rows or more, NO file is produced at all. NO warning or error messages are raised by SQL-Developer, it just silently does nothing.
I have read that there is a similar report of malformed JSON being produced under SQL-Developer 19.x, but these problems above appear to be slightly different.
Cheers,
Downunder Dave