For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I've noticed even with a single project loaded, the IDE response times to button clicks (such as editing project properties) has an almost unusable lag. I don't see this with 12.4 on the same host.
I tested it on 19c Version
i have the errors in all case
If you change it to
DECLARE l_clob CLOB := '{"longString": "This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long."}';BEGIN --5031/4=1257.75 DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (5031) ERROR ON ERROR))); BEGIN DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (5031) ERROR ON ERROR))); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line (SQLERRM); END; l_clob := '{"longString": "This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long."}'; --10032/4=2508 DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (10032) ERROR ON ERROR))); BEGIN DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (10032) ERROR ON ERROR))); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line (SQLERRM); END; l_clob := '{"longString": "8 "}'; DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (8) ERROR ON ERROR))); BEGIN DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (8) ERROR ON ERROR))); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line (SQLERRM); END;END;/
DECLARE
l_clob CLOB
:= '{"longString": "This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long."}';
BEGIN
--5031/4=1257.75
DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (5031) ERROR ON ERROR)));
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line (SQLERRM);
END;
l_clob :=
'{"longString": "This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long."}';
--10032/4=2508
DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (10032) ERROR ON ERROR)));
l_clob := '{"longString": "8 "}';
DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (8) ERROR ON ERROR)));
/
it will work.