Skip to Main Content

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!

changed behavior of SDO_UTIL.GETVERTICES

_jumOct 21 2022

As of ORA 19 there is a changed behavior in the function SDO_UTIL.GETVERTICES:
grafik.pngBut the default result is not as in the previous versions and not as with DEFAULT value NULL:

--should return same as NULL (DEFAULT)
--not ok, returns only coordinates
SELECT * 
 FROM sdo_util.getvertices(sdo_geometry(2001, NULL, NULL, sdo_elem_info_array(1,1,1,3,1,0), sdo_ordinate_array(10,10,0.5,0.866)));

grafik.png

--NULL as parameter include_oriented_pt
--returns both the coordinates and the orientation vector
--ok
SELECT * 
 FROM sdo_util.getvertices(sdo_geometry(2001, NULL, NULL, sdo_elem_info_array(1,1,1,3,1,0), sdo_ordinate_array(10,10,0.5,0.866)),NULL);

grafik.png

--returns only the coordinates of the vertices 
--ok
SELECT * 
 FROM sdo_util.getvertices(sdo_geometry(2001, NULL, NULL, sdo_elem_info_array(1,1,1,3,1,0), sdo_ordinate_array(10,10,0.5,0.866)),0); 
<img src="https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/TC6ZCF6H01HJ/grafik.png" alt="grafik.png">--returns both the coordinates and the orientation vector
--ok
SELECT * 
 FROM sdo_util.getvertices(sdo_geometry(2001, NULL, NULL, sdo_elem_info_array(1,1,1,3,1,0), sdo_ordinate_array(10,10,0.5,0.866)),1); 

grafik.pngSo we have to reprogram the "legacy"-code

This post has been answered by _jum on Nov 1 2022
Jump to Answer
Comments
Post Details
Added on Oct 21 2022
8 comments
390 views