Hot Search: webi report trace mac address on network Go Launcher themth lenovap1a42 how to stop OfficeClickToRun.exe webview back button doesnt work J2SE 1.4 release date Message no. AC551
Home >Default > Web Service and Oracle HTTP Server

Web Service and Oracle HTTP Server

2015-12-10 | Default
Advertisement
I have a web environment with Oracle Database 10.2.0.3 , oracle http server (using mod_plsql), Oracle pl/sql web toolkit. I need to create a web service that is accessed externally which will interact with the database (select, insert, delete). Is it possible to publish a web service to the Oracle Http Server or to implement web services with the environment above

Latest answer

Advertisement
Hello,
In RDBMS 10g you cannot directly expose WS from the DB you need to use the OracleAS Web Service Runtime to do it, following this documentation:
- Developing Web Services that Expose Database Resources
This is true if we are talking about "tooling/runtime/API" but after all Web Services are mainly XML (WSDL and SOAP) so it is still possible to create by hands (PL/SQL & static files) but it is probably a long work depending of the complexity of your services.
Also, in RDBMS 11, you can now directly expose WS from the DB using the embedded HTTP server, see this Oracle 11g New Features Document
Note that before taking one approach you must take time to write up your requirement regarding Web Services eg: do I need security, which time of encoding, interoperability, ..., ... For example WS-Security that is the standard to secure SOAP messages is not (yet) supported by the Oracle 11g RDBMS Native Web Services... where when you do use the WS-Runtime you can secure the Web Service..
Regards
Tugdual Grall

Related recommended

How to deploy a web service on Oracle Application Server 10.1.2.0.2?

Hi everyone, I followed the instructions of the following link to create a web service using jDeveloper 10.1.3.1.0 on Oracle Application Server 10.1.2.0.2. [http://st-curriculum.oracle.com/obe/jdev/obe1013jdev/10131/devdepandmanagingws/devdepandmanag [More]

2015-10-11 Default

Deploying a web service on Oracle application server

Hi; I was able to create the .wsdl file from Elipse using Java 1.3. I was not able to connect to the oracle Application server from eclipse is there any other way to deploy the web server. Can anyone advise with the steps to deploy a web service on O [More]

-0001-11-30 Default

Web Service and Oracle HTTP Server

I have a web environment with Oracle Database 10.2.0.3 , oracle http server (using mod_plsql), Oracle pl/sql web toolkit. I need to create a web service that is accessed externally which will interact with the database (select, insert, delete). Is it [More]

2015-12-10 Default

Deploying a web services on Oracle Application Server

Hi, it is possible to deploy a web services generated by axis on Oracle Application server ? and if it is how ? Thanks,Hello again. Thx for the reply. I have all specfic Libraries in my ear file, but i don't get the problem solved. I can see the exam [More]

-0001-11-30 Default

Deploying Web services on Oracle Application Server

Hi, I am not sure whether this is the forum where I should post this question. I am trying to deploy a webservice on Oracle iAS version1.0.0. But when I navigate to Oracle CRM Administrator(responsibility)-->Integration-->services I get a message te [More]

-0001-11-30 Default

Web Services Examples - Oracle Application Server

Can you please get ahold of the people who write the sample code for the following link and provide the sample code (the code is not present at the link provided): http://www.oracle.com/technology/tech/java/oc4j/1013/how_to/how-to-ws-bottomup/doc/how [More]

-0001-11-30 Default

No web services show under web services node in app server navigator

Hi, (JDev 11.1.1.5.0 and WLS 10.3.3.0) In JDeveloper Help, the topic Publishing Web Services to a UDDI Registry says: 1. Deploy the web service to Oracle WebLogic Server. 2. In Application Server navigator, expand the application server node. 3. Expa [More]

-0001-11-30 Default

Error deploying Web Service in Oracle 10g AS (10.1.3.0)

When deploying a secured web service from Oracle EM 10.1.3 i'm getting the following exception "Failed in uploading archive. Invalid archive file: Invalid value: AES-256" The same web service (.ear) file is getting uploaded without exception whe [More]

2015-10-11 Default

Confirming method to secure web services through oracle web service manager

Hi All, I am just wondering about the method to secure web service through oracle web service manager. I have a unsecure web service "helloworld" which is deployed on JWSDP1.6 toolkit.I want to secure it through oracle web service manager. Inord [More]

2015-10-11 Default

Calling web service in Oracle Applications using Forms....

Can I call a web service in Oracle Appications 11.5.10? I created a simple form on my local machine and invoked the webservice in that form and it works perfectly. I used Oracle forms 9i and 6i for this purpose and both are working perfectly. But whe [More]

2015-10-11 Default

Click Ranking

  • Is all Mac Book Pro Clients having this downloading everyday :System,Version,10.9.5,(Build,1334)  "App,Store",Version,1.3,(201.7).

    Hello my name is Icurez, My Console has been busy full time doing everything repeatedly over everyday for almost two weeks now.installing and deinstalling < detailing every let item in this Mac Book and I'm reading descriptions like "CRITICAL"

  • HT2801 Can I use a USB external DVD drive for mac pc for a ibook g4 to install tiger

    Wondering if I can use a externl disc drive for mac pc for ibook g4Many PPC Macs won't boot from USB drives in OSX, but many can be made to... http://hints.macworld.com/article.php?story=20060301112336384 Works with USB1.1 also, but really slow.Read

  • "Could not open key: HKEY_Local_Machine\SOFTWARE\Microsoft\Windows\CurrentV

    What is the next step for this installation problem? I have no idea what "key" this message is talking about or how to address it. Please help. I can't download the latest iTunes and now I can't use the iTunes store through my old iTunes either.

  • ITunes crashed during download. Now what?

    I just bought an album and while downloading iTunes crashed. So now I spent $8 and have no music to show for it. What can I do? I'm really ****** off...My iTunes (7.0 and now 7.0.1) keeps crashing once it begins to download my purchased music. In fac

  • Import Slide Show

    I created a slide show in iPhoto 9.1.5 and exported it to QuickTime. The .mov is 8.2 meg residing on my desktop. I imported it to FCE. I created a new sequence, in an existing project, and double clicked the sequence. The sequence appeared in the tim

  • Is there an easy way?

    Is there an easy way to tell if all the variables between changing parts of an array are null? Ex: If all object variables between index 4 and 10 are null, do this... ex 2: If all object variables between index 0 and 3 are null, do this... etc.You me

  • Cannot connect anymore to WPA2 Personal after upgrade

    Hi everybody, I'm writing because I cannot access anymore my Wi-Fi WPA2 Personal after I upgraded successfully this morning my Macbook, I bought it at the end of 2008. The wireless icon on top right shows me the ! (exclamation mark), the IP address i

  • Shifting from procedural to object oriented

    Hi people, I've been programming in ABAP in a procedural fashion since I started, because that's the way I was taught. Now I want to slowly shift to object oriented development. I know and understand all object oriented concepts (please don't copy pa

  • Synchronous Message Logging in AAE

    HI, We are on PI 7.1.1 Our scenario is Synchronous Abap Proxy to JDBC via Advanced Adapter Engine(Integrated Config) However we find that messages are not logged in RWB message monitoring. From JDBC comm channel monitoring we can see the message that

  • Date Based Calculations

    We have the following requirements: 1.     In terms of minutes provide the difference between the expected time and actual time of arrival 2.     With a tolerance level of 5 minutes compare expected and actual time dates providing an On time value Ar