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:
When I run
create public synonym blackPackage for purpleUser.blackPackage
, how can I say if it's pointing to object typeprocedure
ouundefined
?How can I drop this
undefined
object?Using this, I discovered
purpleUser
has 'N' on it. Should be 'Y' to allow creating synonyms?