0

I'm struggling on creating synonyms for some package (that compiled successfully). Java application display this error:

identifier 'blackPackage' must be declared

When I try create public synonym blackPackage for purpleUser.blackPackage I got this error:

ORA-38818
Description: illegal reference to editioned object purpleUser.blackPackage

Then I tried all_objects, I got this:

enter image description here

  1. When I run create public synonym blackPackage for purpleUser.blackPackage, how can I say if it's pointing to object type procedure ou undefined?

  2. How can I drop this undefined object?

  3. Using this, I discovered purpleUser has 'N' on it. Should be 'Y' to allow creating synonyms?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.