JSON syntax error (conversion Collection type to Clob)

Database: Oracle 19c
Toad version: 14.1.120.923

declare
t_arc mkc_tp_archive_list := mkc_tp_archive_list();
l_return clob;
begin
select json_object(t_arc returning clob)
into l_return
from dual;
end;

Clob result like [...]

I'm getting a (Toad) syntax check error on above code (conversion Collection type to Clob), whilst this is valid code for Oracle it self (it compiles and works fine). A solution is to add a value ('X'), but this will create a new (unwanted) "layer" in the json result.

select json_object('X' value t_arc returning clob)
...
Clob result like { "X": [...] }

Got it. Will be fixed whenever you see QP5.dll version 5.369 (or higher) in the code base, should be within 1-2 weeks.

Thanks for reporting!
Andre

1 Like

Hi Andre,

How (where) do I get the (this) latest version of that specific library QP5?
Thanks in advance!

Kind regards, Wietze

Hi Wietze,

The library just became available for Toad team to pick it up, so you should see it soon.

Thanks,
Andre

Hi Andre,

We have installed TOAD version 14.1.120.923, the most recent version.
Can we download the most recent version of the QP5.dll library "separately" somewhere?
Thanks in advance!

Kind regards, Wietze

Hello Wietze,

Let the Toad team answer that question ...

Thanks,
Andre

Hi Wietze,

The version of QP5 that should contain this fix is available in Toad for Oracle Beta 14.2.71 and higher, and will be available in the full 14.2 version once it's released in about a month or so. Unfortunately, there is no separate download for QP5 standalone. The best way to get it is to download the beta and use it with that version of Toad.

You can find the beta version here:

Feel free to give it a shot there and let us know if you run into any problems.

Thanks,

-John