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

Last updated on JULY 20, 2024

Applies to:

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

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