PL/JSON Not working On 12c R2 database

Brought to you by: jkrogsboell, jsumners, lewiscunningham

This project can now be found here.

PL/JSON Not working On 12c R2 database

Forum: Help

Creator: prethviraj

Created: 2017-07-28

Updated: 2021-03-19

prethviraj - 2017-07-28

Hi Team,

PL/JSON codes are not compailing on 12c R2 database .types are going into invalide state (i.e JSON,JSON_VALUE,JSON_LIST)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

prethviraj - 2017-08-05

This issue got resolved . by recreating json_value to cust_json_value

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- George Thomas - 2021-03-19
  
  Just recreating json_value with another name will help? I have used schema.json_value in all references, many compiles, But still types like JSON, JSON_LIST etc not compiling Can you explain little more, what else you did other than just changing the name. Please help
  George
  
  Last edit: George Thomas 2021-03-19
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Baris - 2020-08-13

Hi,

I have exactly the same problem. These types are invalid.
Could you elaborate your solution?

Thanks in Advance

Last edit: Baris 2020-08-16

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Alper - 2020-10-13

we have upgraded databases 11.2.0.4 to 19.8.0.0. But, some PLJSON schema objects invalid. Do you have any idea or advise?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.