This content has been marked as final. Show 8 replies
Maybe also try to see if SRID=4326 exists in MDSYS.CS_SRS table?
Sorry, I didn't mention, yes I checked that. It is in cs_srs
select * from mdsys.cs_srs where srid = 4326
"WGS 84";4326;4326;"EPSG. See 3D CRS for original information
source.";"GEOGCS [ "WGS 84", DATUM ["World Geodetic System 1984 (EPSG ID
6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137, 298,257223563]],
PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree",
0.01745329251994328]]";"(; ; ; ; )"
Then you can alter session set NLS_NUMERIC_CHARACTERS = '.,' to see if it is really caused by ',.'
But the problem is 10.2.0.2 is a little bit old. Not sure if you will get a 10.2.0.2 patch if this is a bug.
The Customer tried to create the index after
alter session set nls_numeric_characters='.;';
but the error stays the same.
Maybe ask the customer to upgrade its db to 10.2.0.4/5 or 11gR2
as 10.2.0.2 is a little bit old.
I already asked him to upgrade to 10.2.0.4 which is our standard, but it will take a while.
it is not the db version. It is a wrong entry in cs_srs.
ALTER SESSION SET NLS_TERRITORY=AMERICA
alter trigger MDSYS.CS_SRS_TRIGGER disable;
update cs_srs set wktext = MDSYS.sdo_cs.internal_det_srid_wkt(4326) where srid = 4326;
alter trigger MDSYS.CS_SRS_TRIGGER enable;
select wktext from cs_srs where srid = 4326;
will correct hte fault. (solution found on : http://database.itags.org/oracle/204386/)
The Workaround worked.