Quest Forum Digital Event 2020
The majority of modern IT solutions consist of multiple systems communicating using APIs. The “common language” is usually JSON. Unfortunately, the Oracle RDBMS did not have native JSON support until version 12c. Previously, developers had to use either third-party tools (the most popular was PL/JSON) or write their own code to support JSON processing. When it comes to database upgrades, the question arises: Should we utilize new features or not? This question is especially relevant when you need to edit 10,000+ lines of code and core system functionality. The authors decided to accept a challenge and migrate from PL/JSON to Oracle native JSON and share their story with conference attendees.