Home » Server Options » Spatial » HOW TO CREATE TRIGGER ON SPATIAL DATA
HOW TO CREATE TRIGGER ON SPATIAL DATA [message #170690] Thu, 04 May 2006 17:32
saanvi
Messages: 2
Registered: May 2006
Junior Member
I AM TRYING TO CREATE A TRIGGER BEFORE INSERT IN TABLE CONTAINING SPATIAL DATA. I WANT TO CHECK IF THE NEW OBJECT IS OVERLAPPING EXISTING OBJECTS IN THE TABLE.
HOW CAN I RETRIEVE SDO_GEOMETRY TYPE AND CHECK IT. CAN I DO IT USING SDO_RELATE WITH "DISJOINT".

THANKS
Previous Topic: Geometry Type SQL Query
Next Topic: OCI -> PL/SQL Conversion?
Goto Forum:
  


Current Time: Tue Mar 19 01:02:15 CDT 2024