RishOraDev's Oracle Blogs

In my previous posts, while explaining JSON Relational Duality Views, I mentioned that I encountered ORA-40478: output value too large. So, in this post, let’s look at the available options to by-pass ORA-40478. But first, the basics. Let’s understand what the JSON_SERIALIZE functions does. The function takes JSON data of any SQL data type ( BLOB,CLOB, JSON, VARCHAR2, or VECTOR