My Oracle Support Banner

GeoJson To sdo_geometry fails with ORA-07445 'qjsnRetGeo' (Doc ID 2632556.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Spatial and Graph - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 Database upgraded from 18.2 to 19.5.

Following SQL fails with ORA-07445

SQL> select  JSON_VALUE(GEOTYPE ,'$' RETURNING SDO_GEOMETRY) as geo
   from json_table('{"type":"LineString","coordinates":[[522967.33783563285,6726161.056502306],[523093.458976041,6726229.849816829],[523226.2683272657,6726236.538027645]]}', '$'
   columns ( "GEOTYPE" varchar2(3000) format json path '$'
       )) ;       2    3    4
select  JSON_VALUE(GEOTYPE ,'$' RETURNING SDO_GEOMETRY) as geo
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 19405
Session ID: 1004 Serial number: 38446

 ORA-07445 [qjsnRetGeo()+286] [SIGSEGV] [ADDR:0x0] [PC:0xC2B693E] [Address not mapped to object]

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


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