[This topic is migrated from our old forums. The original author name has been removed]
I'm trying to create a trigger on a table in Oracle that makes use of SDO_UTIL packages installed in the database. DbVisualizer is unable to perform the requested action, and the trigger is stored incomplete. Running the same command in SQL Developer creates the trigger without any problem. What am I missing here?
Explanation: GEOMTEXT contains spatial geography in WKT (well-known text). The trigger converts it to SDO_GEOMETRY format prior to insertion of the record.
CREATE OR REPLACE TRIGGER DWIHV.ref_mobiel_schouw_trg
BEFORE INSERT OR UPDATE
FOR EACH ROW
IF (sdo_util.VALIDATE_WKTGEOMETRY(:new.GEOMTEXT) = 'TRUE' and :new.ligging is null) THEN
:new.ligging := sdo_util.FROM_WKTGEOMETRY(:new.GEOMTEXT);
:new.ligging.SDO_SRID := '28992';