Current position:  Home > Default > Web Service and Oracle HTTP Server

Web Service and Oracle HTTP Server

Time:December 10
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
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

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

2015-10-11

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

Deploying a web service on Oracle application server

-0001-11-30

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

Deploying a web services on Oracle Application Server

-0001-11-30

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

Deploying Web services on Oracle Application Server

-0001-11-30

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

Web Services Examples - Oracle Application Server

-0001-11-30

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

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

-0001-11-30

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

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

2015-10-11

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

Confirming method to secure web services through oracle web service manager

2015-10-11

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

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

2015-10-11

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

Calling web service in Oracle Applicaitons...

2015-10-11

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

Configuring Web Services for Oracle XML DB

-0001-11-30

Hi all... I think I need some help one this subject.... We have a 10G Release 2 Oracle single instance ( not RAC) install on a Linux Redhat v5.3 64 bit server. Are developers are user Visual Studio .Net and wnat to send xml files to a web service so

Error while invoking a WS-Security secured web service from Oracle BPEL..

2015-10-11

Hi , We are facing some error while invoking a WS-Security secured web service from our BPEL Process on the windows platform(SOA 10.1.3.3.0). For the BPEL process we are following the same steps as given in an AMIS blog : - [http://technology.amis.nl

Calling web service from oracle forms 10g

2015-10-11

Problem Description: I'm following the steps as per the doc: http://www.oracle.com/technology/products/forms/htdocs/10gr2/howto/webservicefromforms/ws_10_1_3_from_forms.html to create a java stub to call external web service and then use java importe

Calling web service from oracle forms fails with ORA_JAVA.JAVA_ERROR

2015-10-11

Problem Description: I'm following the steps as per the doc: http://www.oracle.com/technology/products/forms/htdocs/10gr2/howto/webservicefromforms/ws_10_1_3_from_forms.html to create a java stub to call external web service and then use java importe

Error while trying to call external  web service from oracle PL/SQL 10.2 g

2015-10-11

Hi I am trying to call an external web service from oracle PL/SQL .I am getting following run time error when I try to set the opeartion style. But as per the oracle documentation this is one of the 2 valid values. ORA-29532: Java call terminated by

Not able to deploy axis2 web service on oc4j 10g server

2015-10-11

Not able to deploy axis2 web service on oc4j 10g server, getting internal server every time I click on services link.... Edited by: 974237 on Nov 30, 2012 4:17 AMNot able to deploy axis2 web service on oc4j 10g server, getting internal server every t

Unable to start report service on Oracle application server 10g

2015-10-11

Hello, I tried starting services on Oracle application Server 10g using opmnctl startall but got the error below while starting the report service : linux_thin> opmnctl startall opmnctl: starting opmn and all managed processes... ====================

Install and configure report service on Oracle Application Server 10g

2015-10-11

i want to know how to install and configure report service on Oracle Application Server 10g Release 3 (10.1.3.1.0) Thanksthe case is that we developed an ADF Application, so we want to deploy it on the latest version of Oracle Application server. our

How Can I install Web Service on Oracle 11g r1?

2015-10-11

How Can I install Web Service on Oracle 11g r1?Hi, Is necesary install XDB? Because i have executed; select * from dba_registry where COMP_ID = 'XDB' Oracle XML Database RegardsRead other 4 answers