[This topic is migrated from our old forums. The original author name has been removed]
Hi,
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
ON DWIHV.ref_mobiel_schouwovertreding
FOR EACH ROW
BEGIN
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';
END IF;
END;
Hi,
Please check the following page in the users guide:
http://confluence.dbvis.com/display/UG91/Executing+Complex+Statements
Does it help?
Regards
Roger
a
anonymous
said
about 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Oracle Spatial support problem
Hi Roger,
Actually, it did. Just tested the encapsulation with --/ / and that worked just fine.
Thanks for your support!
Regards,
Edwin
anonymous