One of our database appeared this error after compiling some package and this package remain invalid state.
PLS-00907 : cannot load library unit schema.package
PL/SQL is unable to find and load a library unit that was previously available. This typically happens when you try to load a unit which references another library unit that is non-existent or invalid.
alter system flush shared_pool;
after that package compilation run successfully.