Start a new topic

Oracle Spatial support problem

[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;

[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
[This reply is migrated from our old forums.]

Re: Oracle Spatial support problem
Hi, Please check the following page in the users guide: http://confluence.dbvis.com/display/UG91/Executing+Complex+Statements Does it help? Regards Roger