When i connect to Oracle using database links in SQL Developer, I can't get Packages and other objects of the remote database on the left console tree. What can be done that when I connect to remote database I get the procedures & packages of the remote database in SQL Developer console tree.
Looks odd, right?
Actually, there is a firewall between the remote database, and access is available only to one host on our end. How can users on our end access the remote database seamlessly? I know this scenario requires a diagram, but if anybody could understand, please comment.
Do you think we should do some kinda ip forwarding or remote listener thingy?