2 Replies Latest reply: Jun 29, 2012 12:15 AM by don123 RSS

    topology error

    don123
      hi, i am getting following error when add feature table to topology, any way to resolve ??

      SQL> CREATE TABLE LAND_PARCELS(FEATURE_NAME VARCHAR2(30) PRIMARY KEY, FEATURE SDO_TOPO_GEOMETRY);

      Table created.

      SQL> EXECUTE SDO_TOP.ADD_TOPO_GEOMETRY_LAYER('CITY_DATA', 'LAND_PARCELS', 'FEATURE', 'POLYGON');
      BEGIN SDO_TOP.ADD_TOPO_GEOMETRY_LAYER('CITY_DATA', 'LAND_PARCELS', 'FEATURE', 'POLYGON'); END;

      *
      ERROR at line 1:
      ORA-06550: line 1, column 7:
      PLS-00201: identifier 'SDO_TOP.ADD_TOPO_GEOMETRY_LAYER' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored


      thanks..