'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 |
---|