CODEWITHSUNDEEP
jsonoracle-database
Kleinedruif
Kleinedruif

Reputation: 3

How to disable/remove JSON native support in Oracle 12.2

I'm working on a Oracle 12.2 database and I want to turn it off/remove/disable the default JSON support.

The project I'm working on already had a JSON library for all the JSON interactions. My database has recently been updated from 12.1 to 12.2 and now the original JSON library will not compile anymore. After some searching I found that is has conflicts with default implementation of JSON in 12.2, and this didn't occur in 12.1. Some syntax is shared between the old library and the new JSON support.

It is gone be a lot of work to change all my old code to work with the new JSON support, so I would rather disable the JSON support and keep using my old library. But I was not able to find on the internet how do this.

Upvotes: 0

Views: 184

Answers (1)

mark d drake
mark d drake

Reputation: 1505

The JSON support is native, eg it is part of the RDBMS 'C' code. It is not possible to remove it. Can you post the details of the library you were using and the conflicts so we can document them and make recommendations on how to migrate. It was introduced starting with 12.1.0.2.0 (which 12.1 version were you working with ?). Assuming your library is a set of PL/SQL functions you should be able to avoid conflicts by properly qualifying your function names with a schema, which might be less work than doing a full migration, however I would strongly recommend migrating to the native JSON support ASAP, as it is probably much more performant.

Upvotes: 1

Related Questions