Spatial Query Returns NULL Instead Of The Expected Geometry (Doc ID 2664670.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

For a valid geometry sdo_buffer query produce the NULL while the expected value is not a NULL but a geometry.

SELECT sdo_geom.sdo_buffer(sdo_geometry(2003,
                                        NULL,
                                        NULL,
                                        sdo_elem_info_array(1, 1003, 1),
                                        sdo_ordinate_array(....)),0.3,0.005) from dual;

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.