6 Replies Latest reply on Jan 23, 2020 6:55 AM by martv

    GeoJson to sdo_geometry

    martv

      Hi,

       

      I've upgraded from DB 18.2 to  "Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production

      Version 19.5.0.0.0"

       

      Following selects ( 1 and 2 ) used to work on 18.2

       

      1)

        select  geo

          from json_table('{"type":"LineString","coordinates":[[522967.33783563285,6726161.056502306],[523093.458976041,6726229.849816829],[523226.2683272657,6726236.538027645]]}', '$'

          columns ( geo varchar2(3000) format json path '$'

              )) ; 

      2)

      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 '$'

              )) ;     

      3)       

        select  geo

          from json_table('{"type":"LineString","coordinates":[[522967.33783563285,6726161.056502306],[523093.458976041,6726229.849816829],[523226.2683272657,6726236.538027645]]}', '$'

          columns ( geo sdo_geometry  path '$'

              )) ;

       

      On 19.5

           select 2 is not working anymore, disconnected from DB.

           tried select 3 but also disonnects from DB.

       

      Any idea?

      Greetings