Database Software

Hi,

I never able to execute validate_layer procedure. Although I can use validate_geometry procedure for all records in the table, but it is easy to run validate_layer instead. I just like to know what is the error in statement. I have tried the procedure for all my spatial layers, but never successfully completed.

Here is the statement I executed, and error message returned.

SQL> begin
2 sdo_geom.validate_layer
3 ('TAS_GRID','GEOM','OBJECTID','VALIDATION_RESULTS');
4 end;
5 /
begin
*
ERROR at line 1:
ORA-13268: error obtaining dimension from USER_SDO_GEOM_METADATA
ORA-06512: at "MDSYS.SDO_GEOM", line 4046
ORA-06512: at line 2

The entry for the table USER_SDO_GEOM_METADATA:

SQL> select * from user_sdo_Geom_metadata where table_name = 'TAS_GRID';

TABLE_NAME
--------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------

DIMINFO(SDO_DIMNAME, SDO_LB, SDO_UB, SDO_TOLERANCE)
--------------------------------------------------------------------------------

SRID
----------
TAS_GRID
SHAPE
SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', 0, 1000000, .0005), SDO_DIM_ELEMENT('Y', 5000

000, 6000000, .0005))

I have checked the extent of the data. The diminfo I entered is correct. What else do I need to check up?

Thanks

Helen