My Oracle Support Banner

APEX Using SQL With Json Table Is Returning An "Internal Server Error" - 7445 (Doc ID 2262789.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Application Express (APEX) - Version 5.0.4.00.12 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
*** Checked for relevance on 17-Feb-2019 ****

Symptoms

On Apex 5.0.4.00.12

When attempting to create a report region using SQL with json table gets an "Internal Server Error" 

ERROR:
*****************
ORA-07445 [qknExpRegIni_int()+100]

Changes

Using APEX SQL query on JSON table 


The error occurs:

 when validating SQL in the "SQL Query" edit box
 when saving the page containing the "Classic Report"
 when opening the "Classic Report" page for editing.

Same test work with SQL Developer and SQL Plus but not with the APEX interface

The query is like:

SELECT <COLUMNS> 
FROM
JSON_TABLE (
'{"data":[{<VALUES>}'
, '$.data[*]'
COLUMNS (
<NAME1> VARCHAR2 ( 50 CHAR ) PATH '$.<NAME1>',
<NAME2> VARCHAR2 ( 500 CHAR ) PATH '$.<NAME2>',
...
<NAMEN> VARCHAR2 (3000 CHAR ) FORMAT JSON PATH
'$.<NAMEN>'
)
)

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.