Using Oracle SQL Developer I'm trying to access a given package that has been created by SYS and in which the, say, FOO schema has EXECUTE and DEBUG permissions, in fact executing a desc will produce the following output:
desc SYS.PKG_MY_PACKAGE
PROCEDURE Argument Name Type IN/OUT Default
-------------- ------------- -------- ------ -------
PRC_MY_PROCESS P_MY_ARGUMENT VARCHAR2 IN unknown
The problem is such package is not visible under Connections > My Connection > Packages.
Any feedback will be sincerely appreciated. Thanks much in advance.
The only way I've found to do this is to select "Other Users" under My Connection, expand the SYS user, and go to Packages in there.
IOW,
Connections > MyConnection > Other Users > SYS > Packages