'Oracle, Parse JSON with > 4000K

I am trying to parse some JSON like this:

SELECT cid, c_message
FROM JSON_TABLE('{"cid":"30152","c_message":"....very long message...."}'
FORMAT JSON,'$[*]'
       COLUMNS (cid                  NUMBER          PATH '$.cid',
                c_message            VARCHAR2(4000)  PATH '$.c_message'));

The issue here is that c_message is > 4000 bytes. And, I have tried making the length VARCHAR2(32000) and it still does not work.

How can I parse the JSON when the length exceeds 4000k?

Thank you!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source