Home » Server Options » Spatial » Getting Errors
Getting Errors [message #170721] Thu, 04 May 2006 23:14 Go to next message
saanvi
Messages: 2
Registered: May 2006
Junior Member
I am trying to do following

INSERT INTO user_sdo_geom_metadata VALUES
('tabname','data_geom',
MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',0,4,0.5),
MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('Y',0,4,0.5)),
NULL
);

When I executed it for the first time it did not give any errors but afterwords it is giving error

insert into user_sdo_geom_metadata values
*
ERROR at line 1:
ORA-00001: unique constraint (MDSYS.UNIQUE_LAYERS) violated
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 27
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'

Is it happening because I am trying to give meta-data for same table again.

thanks
Re: Getting Errors [message #172644 is a reply to message #170721] Wed, 17 May 2006 08:13 Go to previous message
pgroen
Messages: 4
Registered: May 2006
Junior Member
Exactly!

It doesn't make sense to have more than one metadata-entry for a given column...
Previous Topic: OCI -> PL/SQL Conversion?
Next Topic: ORA-13193: failed to allocate space for geometry
Goto Forum:
  


Current Time: Thu Mar 28 15:43:03 CDT 2024