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 220.127.116.11 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;
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..