Skip to Main Content

APEX

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!

Apex 21.2: sample maps app SDO_GEOMETRY column, how to handle?

SmithJohn45Dec 6 2021

installed sample maps app from Gallery.
[we knew that most of the data available online which can be use but what if we want to give user interface to made some minor changes in Longitude and/or Latitude data to pin point the location]
created paage, Form -> Report with Form on table EBA_SAMPLE_MAP_AIRPORTS where a column is present as "GEOMETRY" "MDSYS"."SDO_GEOMETRY" which contains data (i think in JSON) as: [Point (-176.6425,51.8836)]
when page created i go to data entry Form it generated but failed to see how it has been managed to input data for this SDO_GEOMETRY column. table structure says it is VARRAY but i want to know how in Form and/or editable IG user will enter the required data? i don't know how to handle it and in sample maps app there is nothing to understand. so, please help as this is starting point to have maps in our app.
regards.

Comments
Post Details
Added on Dec 6 2021
2 comments
787 views