Sitemap

Amicuk Programming Answers

Web Service and Oracle HTTP Server

2015-12-10   Views:508

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

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

The replay 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

Go to See the other 2 answers

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

Category:DefaultRelease time:2015-10-11Views:130

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]

Deploying a web service on Oracle application server

Category:DefaultRelease time:-0001-11-30Views:130

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]

Web Service and Oracle HTTP Server

Category:DefaultRelease time:2015-12-10Views:130

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]

Deploying a web services on Oracle Application Server

Category:DefaultRelease time:-0001-11-30Views:130

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]

Deploying Web services on Oracle Application Server

Category:DefaultRelease time:-0001-11-30Views:130

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]

Web Services Examples - Oracle Application Server

Category:DefaultRelease time:-0001-11-30Views:130

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]

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

Category:DefaultRelease time:-0001-11-30Views:130

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]

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

Category:DefaultRelease time:2015-10-11Views:130

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]

Confirming method to secure web services through oracle web service manager

Category:DefaultRelease time:2015-10-11Views:130

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]

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

Category:DefaultRelease time:2015-10-11Views:130

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]

Calling web service in Oracle Applicaitons...

Category:DefaultRelease time:2015-10-11Views:130

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]

Hot
The Style, Font and Font Size dropdowns in the upper left of the RH11 window (above the project manager panel) begin blinking back and forth, in time with the cursor, as soon as more than one Design/HTML tab is opened.  Attempting to drop one of thos [More]
Hi Folks, We have 5 domains in the BPEL console with around 70 active BPEL processess in Clustered BPEL Production Environment on Weblogic server.The total dsp max threads for all domains combined on the 2 BPEL clustered servers is 275 and connection [More]
Hi All I have RAC environment with 8 Nodes (Linux 4) , I have one node as physical standby for this RAC. My oracle is 10.2.0.3 , and i want to update it to 10.2.0.5 Could you please advice me with steps , when i Google i found that i have to start wi [More]
Hi, I have declared a variable P_TEXT in TOP include ZPGM_TOP.  In main program ZPGM, I have declared this TOP include ZPGM_TOP and another include ZPGM_F01. I am  accessing P_TEXT in include ZPGM_F01, but it is giving me following error when I do sy [More]
Hi all, how to get the different no.of output fields for first few records and then it should change for  another few records. any suggestion will be rewarded. regards cnuhi, use blocked alv. example: REPORT  ZSR_ALV_BLOCKED. TABLES:     ekko, mara. [More]
Hi I have a bit of a strange problem. I have a server, thats just been upgraded to 10.8.2 from 10.7.5, when I try and run the server.app to get it all running I can't get past the set up for push notifications, as it says my password is incorrect (it [More]
I've just created a blu-ray project with about 20 timelines.  I created an 35GB ISO file which I burned to a dual layer BD-R disc.  Everything seems to work fine when I play it back on a blu-ray player except for 6 videos/timelines.  They play as a b [More]
Hi All, I am migrating COM+ application from windows server 2003 to windows server 2008. In windows server 2003 , COM + application having "Uses SOAP" section of the Activation Tab and we are using that option so far. But this featues was not th [More]
Hi All, Is it possible to stop Live cache consistency check program /SAPAPO/TS_LCM_CONS_CHECK  when it is running. Thanks. Bala Message was edited by: Bala SubramainamHi Uma, Actually the job finished quite fast and was unable to check this. Would pr [More]
Where can I download a LabVIEW GPIB driver for an ANDO AQ6315E Optical Spectrum Analyzer? Thanks. Solved! Go to Solution.The Instrument Driver Network has all the drivers for instruments. There is no driver specific to that model, but there is one fo [More]