My Oracle Support Banner

ORA-40596:error Occurred In Json Processing Of JzntSNVAR:1 (Doc ID 2655620.1)

Last updated on MAY 01, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

ORA-40596:error occurred in json processing of jzntSNVAR:1

select count(*) from WITH_EXTRACT_JSON --> No error.
select count(distinct customer_index) from WITH_EXTRACT_JSON --> No Error
select count(distinct customer_value) from WITH_EXTRACT_JSON --> No error.
select count(distinct customer) from WITH_EXTRACT_JSON --> No error.
select count(distinct customer||'-'||customerid||'-'||customer_index) from WITH_EXTRACT_JSON --> Error
select * from WITH_EXTRACT_JSON --> Error when fetching all rows



Changes

After upgrade to 19c

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.