Calling web service in Oracle Applications...

Is there any way we can call web services in Oracle Applications?
I am using 11.5.10 verison of Oracle Applications.
Thanks in advance,


Hey Ravi,
Thanks for your response. I am not well versed with Java. I am using Forms 6i to achieve this. I dont know what java code do I have to put in the custom directory.
The procedure I am following to call web sevice is as follows:
1. Using the webservice URL(.wsdl URL) I am creating the Java class (web service stub) in Jdeveloper.
2. Deploying this Java class into a JAR file.
3. Then I am placing this JAR file in a directory which was spcified in the LD_LIBRARY_PATH and CLASSPATH including the name of the JAR file.
4.Then I go to Forms 6i and say program --> Import Java Classes in my form, it gets the webservice java class and converts that java class into PLSQL packages.proc/func.
Can you please send me an example how you did this to my email?
My email ID is "[email protected]"
Thanks again,

How to call web services from oracle database 10g

Hi all , How can i call web services from oracle database 10g ? thanks ...abdou123 wrote: but how can i get complex result for example i pass input parameter like National Id Number and get the person details ( name , age , date of birth , ..........

Error When using web services on Oracle Application

we are getting this error when we deployed code on Oracle Application, but same code working fine on Jdev. Exception java.rmi.RemoteException: ; nested exception is: HTTP transport error: javax.xml.soap.SOAPException:

Error 504 DNS look up failed while calling web services using XML

Hi, I am trying to call web service from Oracle using XML. Everything seems to be in place but im getting an error "The webserver for <My End URL> reported that an error occurred while trying to access the website. Please click here to return t

Error in BPM application in calling web service

Hello, I have created a BPM application with 3 steps first 2 are human steps and third one is automated step which calls web service interface via WSDL (external system). On third step my process goes to failure and has below error. any help.

Security issues with calling web services from within Oracle?

I'd like to use a trigger to initiate pushing data to a web service, so I thought we should call the web service from PL/SQL in a DBMS job, or perhaps create a .NET stored proc to call the service. Our DB Lead is concerned about security, since the s

Call web service using code.

we want to call a web service from ADF JSP form. We used web service data control. But deployment failed. we applied Patch 5878326 to JDeveloper and OAS. But problem is not solved. So we need a new way to call web services. is there any ot

Add cookie to HTTP request header when calling web service

I'm trying to call web service using JDeveloper 11g. I successfully generated web service proxy from WSDL document. I can successfully call this particular web service's method "login" which returns "session_id", which then needs to be

How to print SOAP request at client program when program calls web service.

Hi friends, While calling a web service, I am getting following error: javax.xml.rpc.JAXRPCException: Failed to parse WSDL I believe it is due to an invalid parameter set for the request soap. I need to analysis this error. Can you help me to print S

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

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

How to call web service using J2SE 1.3?

Dear All, i have developed a web service by jdev 10.1.3 (JAX-RPC with web service security enabled). i generate the ws proxy (jdev 10.1.3) and run it with wsclient_extended.jar (required JDK 1.4.1 or above??). but one of my client say he has to use J

How to integrate Oracle BI Publisher via Web Services in Oracle Forms.

hi I hope you fine and happy. I think you hear about the new reporting tool (Oracle BI Publisher). Really it is a great tool. I need someone help me; How I can integrate Oracle BI Publisher via Web Services in Oracle Forms. I got the guidelines of th

How to do web services between two applications

I have tried to get a complete example about how to do a web service between two applications in ADF but I saw all the put examples that describe only how to do a web service and test it in the same application. Please, I want to see a whole example

Error deploying Web Service in Oracle 10g AS (

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

Calling web service.

Hello, I have designed a form in Livecycle designer in which I am calling web service of coldfusion using javascript, passing a xml file as parameter, so here is the code but not working. But I want to ask that is this the currect way of calling web

Need idea : Integration of CRM On Demand web services with Oracle SOA 10g

Hi Al, Can anyone have any idea on integration of CRM on Demand Web service with Oracle SOA 10g specially BPEL 10g. If you have any idea please share with us. Or if you know any good link on the same... please let me know..... Thanks in advance Debar

Example of Asynchronous Web Service Using Oracle APIs

Greetings, Is there any tutorial, section or example of Oracle, that explains clearly, how to create an Asynchronous Web Service using Oracle APIs. Thakns in advance for your help.-Does this help:

How to copy List item from one list to another using SPD workflow using HTTP call web service

Hi, How to copy List item from one list to another using SPD workflow using HTTP call web service. Both the Lists are in different Web applications. Regards, Shreyas R SHi Shreyas, From your post, it seems that you are using SharePoint 2013 workflow

Calling Web Service from PL/SQL in

We're having some problems getting the "Calling Web Services Sample from PL/SQL" sample working with our database. After downloading the sample from

Server-Services property called Web Services Listener in Enterprise Server

I am trying to find out the Server-Services property called Web Services Listener Port inside the Enterprise Server web console..but I cannot find it.. In the BPM manuals it is given that:- When using FuegoBPM Enterprise Server, the Port is defined i