Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why is sdo_geom.sdo_buffer return null value?

navaneetOct 22 2018 — edited Nov 2 2018

sdo_geom.sdo_buffer returns null value. Table don't have SRID. Oracle version is 18c (18.0.0.0.0). Any feedback would be appreciated.

1 select g.geom, sdo_geom.sdo_buffer(g.geom,100, 0.01) OUTPUT_GEOMETRY

2 from graphics_TABLE g

3* where rownum < 2

SQL> /

GEOM(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)

--------------------------------------------------------------------------------

OUTPUT_GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDI

--------------------------------------------------------------------------------

SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(

1603899.54, 1155250, 1603899.54, 1155192.46))

Thanks.

Added on Oct 22 2018

#database-key-features, #spatial

12 comments

1,690 views