OraFAQ Forum: Spatial » error while updating SRID to null

Home » Server Options » Spatial » error while updating SRID to null (oracle11g,windows xp)

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

error while updating SRID to null [message #515997]

Thu, 14 July 2011 07:38

swapnabpnn
Messages: 96
Registered: December 2010

Member

Hi,
I am trying to update SRID of a table from 8307 value to NULL.BUt it is throwing following error.

Code: [Select all] [Show/ hide]

SQL> update CABLE a set a.geom.sdo_srid=null;
update CABLE a set a.geom.sdo_srid=null
*
ERROR at line 1:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-13365: layer SRID does not match geometry SRID
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 270

But I tried by keeping in user_sdo_geom_metadata the SRID of cable as 8307.Still it is throwing error as above.

Also I tried by keeping in user_sdo_geom_metadata the SRID of cable as null also.Still it is throwing error as above.

How can I solve this problem.

Report message to a moderator