My Oracle Support Banner

PL/SQL Package with a JSON call causes compile error PLS-00801: internal error Unsupported mode 10 (Doc ID 2831341.1)

Last updated on JANUARY 28, 2022

Applies to:

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

Symptoms

PL/SQL Package with a JSON call causes the following compile error:
PLS-00801: internal error [*** * Unsupported mode 

---------

Analyzing the call we find that the following line was causing the error:

****_p := JSON_VALUE(text_p, '$.meta.code')

---------

As seen in resulted traces:

ASSERT at file ****.c, line 7829; Unsupported mode 10

Stack trace:
pdz2Mz2_Assert_Print()+1556<-pdz2M14_AssertO()+225<-pdynF300_Translate_Operand()+565<-pdynF206_Push_Operand_Using_Template()+91<-pdynF200_Normal_Instruction()+99<-pdynF102_Generate_Block()+256<-pdynF01_Generate()+1210<-pdy1F82_Write_MCode()+864<-pdy1F01_Driver()+247<-pdw0F82_Run_Code_Gen()+158<-pdw0F01_Code_Gen()+344<-phpcmp()+1866<-pcicmp0()+472<-kkxcmp0()+932<-rpiswu2()+2004<-kkxcmp()+231<-kkpcrt()+2447<-opiexe()+28594<-opiosq0()+4494<-kpooprx()+387

Changes

 

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.