OraFAQ Forum: Weblogic & Application Server » Accessing PL/SQL Web Service From The Internet

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Accessing PL/SQL Web Service From The Internet

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Accessing PL/SQL Web Service From The Internet [message #637976]

Sun, 31 May 2015 02:07

elmousa68
Messages: 20
Registered: September 2012

Junior Member

Hi all,

I hope everyone is having a good day.

I have created a web service using the dbms_xdb package. This service has been tested on the local machine in a satisfactory manner.

My question is : in our company, all Oracle forms and reports work within the intranet; nothing is exposed to the internet.

So if I want to access the above service from the internet, what configuration / software / hardware do I need to put in place?

Any thoughts welcome.

Thank you.

Note : we are using Oracle 11g database with Oracle Application Server 10g in a RAC environment.

Report message to a moderator

Re: Accessing PL/SQL Web Service From The Internet [message #637977 is a reply to message #637976]

Sun, 31 May 2015 08:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have created a web service using the dbms_xdb package.

above means that Oracle database must reside om a system that is exposed to the whole internet.
I NEVER would have produced a solution which requires any Oracle DB TOTALLY exposed & vulnerable to world wide hacking.
If you insist this must be deployed as currently coded, I would have no application data actually reside in/on the exposed DB,
& only use XDB as a pass through mechanism.

Report message to a moderator

Re: Accessing PL/SQL Web Service From The Internet [message #637981 is a reply to message #637977]

Sun, 31 May 2015 12:49

elmousa68
Messages: 20
Registered: September 2012

Junior Member

I think that this package is there for a reason. There must be a way to use it to make the db data available to users over the internet without compromising security. Why else would Oracle provide it in the first place?

What is meant by "pass through"?

Report message to a moderator

Re: Accessing PL/SQL Web Service From The Internet [message #637983 is a reply to message #637981]

Sun, 31 May 2015 12:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If you wish to believe that the XDB is 100% secure, then I won't waste my time trying to convince you otherwise.

>What is meant by "pass through"?
It means that I would store the all the application data in a different database which is isolated behind a FireWall & the XDB operates only as intermediary.

Report message to a moderator

Previous Topic:	How to Connect Between Two Different Database
Next Topic:	Weblogic 10.3.5.0 cluster_reports not starting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 21 09:43:52 CDT 2023