Sitemap

Amicuk Programming Answers

Web Service and Oracle HTTP Server

2015-12-10   Views:533

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
hi PLease give me the answer to these questions. session method and call transaction methos which one is the sap recomonded why . 2) if we want to maintain BDC program in all the systems.wt to d0Hi Revethi, Here is the difference between the Session [More]
I just get the spinning ball when I try to sync my iPod classic, 80GB. Had worked OK up to now. I have done reset several times, and I can't get it to the restore mode because of the spinning ball! I would apprciate any advice to solve this unexpecte [More]
My iTunes library is located in the "Shared" users account and pointed to by a folder alias in my own "Music" folder. However, when setting up a slide show in iPhoto, my iTune tracks are not available. In fact iTunes does not even show [More]
Hi. I opened my new macbook air yesterday, and I tried to connect my private WiFi AP. The other devices, such as two iPads, iphone 4, ipod touch 3G, and PCs, can connect to the AP, but the new one couldn't connect. The error message was "The password [More]
I manually created a folder on my Time Capsule called "manual backups" and dragged some folders/files there. (They were dragged over from an external drive, which had files I put on there from my mac. Not using a pc.) A few weeks later I went to [More]
Hi, We have a vendor where we do not know where the goods are being supplied from until they arrive. I would like to be able to choose the GS partner when completing the goods receipt via MIGO - does anyone know if this is possible? Thanks, Steph.Hi [More]
Dear experts,                         Whenever I am making a process order, my by-product is going to the unrestricted storage location through 531 movement but no final inspection lot is generated though I am maintaining inspection plan of origin 05 [More]
How do you access PDF files sitting up on iCloud Drive in the Preview Folder (or even outside the Preview Folder) on either an iPad or an iPhone? Thanks.I was hoping that the Apple would have Preview available. I have PDF Pen Pro. Will check with the [More]
I took a picture with my Ipad and I need to put it in JPEG format and  send it as an attachment to an email.  How do I  do that?I'm new to iOS (iPad ver 7.1), so maybe I have this wrong, but consider this, before adding (yet another) app, just to cha [More]
Hi Friends Please let me know: 1. How to do return delivery of goods receipt & service entry sheet between EBP to SUS in ECS,SRM5.0 2. How to cancel confirmation of goods receipt and service entry sheet between EBP to SUS Regards RenukaHi To cancel a [More]