OraFAQ Forum: Spatial » HOW TO CREATE TRIGGER ON SPATIAL DATA

Members
Search
Help
Register
Login
Home

Home » Server Options » Spatial » HOW TO CREATE TRIGGER ON SPATIAL DATA

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 13:06:01 CDT 2013

Total time taken to generate the page: 0.14298 seconds