1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Using spatial Oracle databases

Discussion in 'General' started by nidhichutani, May 5, 2009.

  1. nidhichutani

    nidhichutani Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Code (SQL):
    INSERT INTO user_sdo_geom_metadata
         VALUES ('polygon', 'shape',
                 MDSYS.sdo_dim_array (MDSYS.sdo_dim_element ('X', 0, 100, 0.005),
                                      MDSYS.sdo_dim_element ('Y', 0, 100, 0.005)
                                     ),
                 NULL)
    Code (Text):

    ORA-00001: unique constraint (MDSYS.UNIQUE_LAYERS) violated
    ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 43
    ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'
    ----i am unable to insert row into USER_SDO_GEOM_METADATA VALUES .
    can anyone help me

    ---n
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    hi u have ORA-00001 error, check your table for duplicate value already existing. There is also an error in your trigger execution, could u post the trigger code.
     
  3. jesthr@gmail.com

    jesthr@gmail.com Active Member

    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    80
    I have Oracle v11g and same geokoordinate data.


    I have SDO two-dimensional X, Y polygon data in the form of Oracle Spatial, which I downloaded Oracle SDO_GEOMETRY in a table.
    I have a data point X, Y, like 335355, 8535548

    How to find ORACLE SQL sentence, if a selected point X, Y within pologona or not.



    Regards!



    Hine