Database Software

Hi,

I have encountered the following error message when I execute SDO_GEOM.SDO_AREA function :
SQL> select sdo_geom.sdo_area(l.geom,0.00001) from tile_boundaries l;
select sdo_geom.sdo_area(l.geom,0.00001) from tile_boundaries l
*
ERROR at line 1:
ORA-13282: failure on initialization of coordinate transformation
ORA-06512: at "MDSYS.SDO_3GL", line 439
ORA-06512: at "MDSYS.SDO_GEOM", line 3514
ORA-06512: at "MDSYS.SDO_GEOM", line 3526

I'm running 9.0.1.2.0. The data has user-defined SRID, as listed below where srid=1000000.

SQL> insert into mdsys.cs_srs ( cs_name, srid, auth_srid, auth_name, wktext )
2 values(
3 'IRENET95_Irish_Transverse_Mercator',
4 1000000,
5 1000000,
6 'Odnance Survey Ireland',
7 'PROJCS [
8 "IRENET95_Irish_Transverse_Mercator",
9 GEOGCS [ "GCS_IRENET95",
10 DATUM [ "D_IRENET95",
11 SPHEROID [ "GRS 80", 6378137.000000, 298.257222]
12 ],
13 PRIMEM [ "Greenwich",0.000000 ],
14 UNIT [ "Decimal Degree", 0.01745329251994330 ]
15 ],
16 PROJECTION[ "Transverse Mercator" ],
17 PARAMETER[ "Scale_Factor", 0.999820 ],
18 PARAMETER[ "Central_Meridian",-8.000000 ],
19 PARAMETER[ "Latitude_Of_Origin",53.500000 ],
20 PARAMETER[ "False_Easting",600000.000000 ],
21 PARAMETER[ "False_Northing,750000,000000 ],
22 UNIT[ "Meter",1.000000000000 ]
23 ]'
24 );

1 row created.

SQL>
SQL> insert into mdsys.cs_srs ( cs_name, srid, auth_srid, auth_name, wktext )
2 values(
3 'GCS_IRENET95',
4 1000001,
5 1000001,
6 'Odnance Survey Ireland',
7 'GEOGCS [ "GCS_IRENET95",
8 DATUM [ "D_IRENET95",
9 SPHEROID [ "GRS 80", 6378137.000000, 298.257222]
10 ],
11 PRIMEM [ "Greenwich",0.000000 ],
12 UNIT [ "Decimal Degree", 0.01745329251994330 ]
13 ]'
14 );

1 row created.
insert into mdsys.sdo_datums (name,shift_x,shift_y,shift_z,rotate_x,rotate_y,rotate_z,scale_adjust)
values (
'D_IRENET95',0,0,0,0,0,0,0
);

From the error message, I realised that the problem may relate to the user-defined coordinate system. So I set the data's SRID to NULL, then calculated area. It worked fine.

I would like to find out the cause of the error. Unfortunately, I couldn't find any reference to "ORA-13282: failure on initialization of coordinate transformation". This is critical, as we need the SRID value to allow projecting data between this and other defined projection.

Could anyone suggest the possible cause?

thank you very much

Helen Dunn