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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 03 04:13:09 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.