Please forgive me, I am new to GIS. I have a table in Oracle with points stored as an SDELOB. Is there a way to read those points for a given row? I have another table that needs those points to be inserted as SDO_GEOMETRY, and I am hoping to create a trigger that can construct the SDO_GEOMETRY using the SDELOB points and insert it into the second table.
No, you don't want to try to read the raw LOB. You could certainly migrate the layer storage from SDELOB to ST_GEOMETRY or SDO_GEOMETRY. Either would then permit transfer to another table via SQL.
No, you don't want to try to read the raw LOB. You could certainly migrate the layer storage from SDELOB to ST_GEOMETRY or SDO_GEOMETRY. Either would then permit transfer to another table via SQL.
