1 Reply Latest reply: Jun 5, 2012 1:26 AM by Merlin128 RSS

    package with sdo_geometry has become invalid

    Merlin128
      I'm confused...
      I verified this package is the same as it was a month ago.. but now it is invalid and will not recompile.. no database upgrades/patches have happened.
      database is 11.2.0.2 patch level 12

      error is PLS-00905 Object sdo_geometry is invalid on:

      I recreated a test package with only this line and it still fails:
      CREATE OR REPLACE PACKAGE "GEOM_OP_TEST" AUTHID CURRENT_USER is
      FUNCTION GET_SIMPLIFIED_GEOMETRY(geom in SDO_GEOMETRY, tolerance in NUMBER) RETURN SDO_GEOMETRY DETERMINISTIC;
      end;

      I have followed ID:270588.1 and verified that spatial is valid and all objects are valid..

      this code does compile if I add MDSYS. in front of SDO_GEOMETRY.. but it has not been that way in the past..
      I verfied that MDSYS.SDO_GEOMETRY is still granted to public..
      I verfied that the public synonym for it still exists and is valid..