Hot Search: webi report the ipod could not be restored 1416 mac recover remote distribution point execute permission denied in ssrs percentage change calculator esso 2.0 0P_PRFP1 jeff crnogorac
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

  • New Development on my iphone from yelling!

    Okay so I posted a little bit ago the post on my iphone having to yell to callers can hear me. It seems that when I plug in my headphones people can hear me thru the headphones mic and when I unplug it callers tell me they hear a squealing noise and

  • Help! Time Capsule set up help: Airport Utility not cooperating

    Hi Everyone, I'm desperate for help with this issue. I have a Time Capsule, Base Station and Airport Express (all previous generation)at different points throughout the house. At first the issue was with the base station that refused to find my netwo

  • How can i move pictures from the phone to the pc?

    How do I move pictures from my cell phone to my PC?Do you get an error when transferring, or do you not see the card/phone show up in a file manager/My Computer?  Do you have the updated drivers for USB from Samsung? If all of this is fine, can you n

  • Unable to create webI report??

    HI all I am using BO XI3.1 SP3, when I logged into infoview and click on the new webintelligence document, I see universes available and select the universe then it is showing as "PLUGIN's NOT INSTALLED" instead of showing the query panel of the

  • Usage of SQL and SQLQuery Component Oracle BPM 10g

    Hey Friends, I have created SQl and SQL query catalog compoenents in Oracle BPM 10g, but unable to figure about how to use them in the BPM process. Do i need to create an automatic activity and make implemenatation as method and write java/pbl code t

  • Mailto with html body for UIApplication sharedApplication

    Hi There, I would like to have my iPhone application be able to email out in html format some local data. After looking at it I have two questions: 1) What is the best way to construct large strings i.e html content. Appending hundreds on lines to an

  • Is there any way to recover sys pass?

    Luckly we found it in an old notebook, but, what would happen if we didn't find it? Do we have to creater a new database and migrate all data, users, etc... from the old one to the new one? Message was edited by: ElidasYou don't have to create a new

  • Change UserConfig via the AddOn mechanism?

    Hi, if I use the Configuration API and set a property via the method setProtperty (com.sap.ip.me.api.conf.Configuration.setProtperty) than the property is saved in the file /setting/<username>.uconfig. The question is. Is there a possibility to over

  • While in Add/Remove Prog. in computer, I found apps named: iPOD for Windows 2006-03-23 (138 Mb) and another 2005-09-23 (106 Mb).  I'm trying trying to free up computer HD space.  What are these and can I delete either?

    While in Add/Remove Prog. in computer, I found apps named: iPOD for Windows 2006-03-23 (138 Mb) and another 2005-09-23 (106 Mb).  I'm trying trying to free up computer HD space.  What are these and can I delete either?Those are outdated iPod software

  • Send from Color back to FCP

    At the point of sending color corrected files back to FCP from Color a window entitled "Send To Sequence Option" come up with the message: "Change graded Final Cut Pro sequence to match the Quicktime export codec?" I'm using Apple Inte