Sitemap

Amicuk Programming Answers

Web Service and Oracle HTTP Server

2015-12-10   Views:637

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
I'm going insane. I waited on hold for something like half an hour before I had to leave for class. Is there an email address for service and support? I need help with the scratch issue. I've had my ipod nano for about a week and a half, I've been ex [More]
Update to latest iOS. Keep getting pop up message to "Connect to iTunes to use Push Notifications". This message will not go away. Any ideas on how to fix?Hi I have the same Problem at my I phone 4s , its killing me all application not working . [More]
Hi, The following scenario I have setup. First I create a new asset. Then I create a Purchase order (PO) with Account Assignment Asset where I use the new created asset. In the PO I use a material with serial number profile. During the Goods Recipts [More]
Some people are reporting this error on one page of a site I am building.  Those users are all using IE for a browser. The site is www.shermanoaksstreetfair.org and it comes up with the main stage schedule page.  I took out all questionable links, bu [More]
Bottom Line:  The resources of my laptop are pretty strained when encoding video.  I am going to aquire a server to run these jobs (instead of my laptop) if there is a way to do this.  Can someone please advise me on the "Whats"? My "What Q [More]
hi i have an flash cs5 project so the user when clicking the button the exe file open ? the exe in folder name "puzz" the exe file name play.exe i tried this     button_1.addEventListener(MouseEvent.CLICK, fl_MouseClickHandler);        function [More]
<blockquote>Locking duplicate thread.<br> Please continue here: [/questions/821055]</blockquote><br> In view drop down menu for encoding middle east languages I don,t see Farsi languageI have this same problem, which began precisel [More]
Hi All, In the risk analysis simulation , what is the meaning of field "Exclude Values:" Thanks YuditHello Yudit, This functionality is used for cleaning the Roles. By cleaning I mean, making the Risk free, so that when you do analysis using RAR [More]
i got an iphone the other day and when i started it up i answered the language questions and i've connected it to the wifi. just when i click next it wont activate, it's unable to connect to itunes as well, please help meFirst things first, You need [More]
Hi Does anybody know about oracle Business object tool ? where i can find institue in Mumbai ? Thanx in advanceDear I m not getting help from Google, thats y i tried to get itRead other 3 answers [More]