Using APEX 19.1 and RDBMS 12.2
I've added an SDO_GEOMETRY column to a table, LOCATION. I have a page 72 with a Form based on that table, with standard DML processing. I want to have that Form update the new column.
Was thinking of putting Page Items on the page - P72_LATITUDE and P72_LONGITUDE, that would not be tied to columns in the table - they would be query only fields with the latitude and longitude extracted from the LOCATION column (I already know that the SDO_GEOMETRY will use the lat/long coordinate system).
I am supposing that I will need to replace the standard DML process with my own PL/SQL process. I'd rather not - there are a lot of columns in that table and on the page. But is there a simpler way?