APEX Using SQL With Json Table Is Returning An "Internal Server Error" - 7445
(Doc ID 2262789.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Application Express (APEX) - Version 5.0.4.00.12 and laterOracle 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.
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 |