I read a lot of examples of publishing pl/sql procedures on the internet using native plsql web serice. They all seem to show the database itself listening on port 8080. However a more likely soulution would be the database connected to another machine typically with an app server on it and that connected to the internet. Is there an out of the box way of connecting the db via another machine to the internet?
my setup will be
11g db sitting on amazon rds
an ec2 on amazon connected to the internet.
would anyone be able to guide me on this?