How to call Oracle SQL Query as a Web Service?

Asked By 0 points N/A Posted on -
qa-featured

I want to start my SQL Query or DML Statement as a Web Service. I already search and read some guides but I wasn't able to followed it correctly. I have Oracle Call-In Web Service Installation or Database Web Service and I need to know how can I implement this with SQL Query. How to call Oracle SQL Query as a Web Service? Can anyone help me by sending resolutions with a much simpler terms?

Thank you.

 

 

 

SHARE
Best Answer by cevvavijay
Answered By 0 points N/A #105884

How to call Oracle SQL Query as a Web Service?

qa-featured

Web service client code that runs in oracle in written in SQL or Java. which calls the external and internal web services. you can also call a service with java code written for webs service. following methods are used to call the web services code written in java.

1. SQL and PL/Sql Call Specs (start web service with user defined function, jpublisher generate this, with a variable or directly with SQL statement.)

2. Java proxy class (Jpublisher generate a client proxy class, in this Java API is used for JAX-RPC, no need to look in UDDI registry, work on request of SOAP class with desired parameters.)

3. DII Over JAX-RPC.

Best Answer
Best Answer
Answered By 0 points N/A #105885

How to call Oracle SQL Query as a Web Service?

qa-featured

This can be performed using the JPublisher utility available in oracle Application server. Below are the sequence of step and a sample example (attached) on how to expose a SQL statement as web service.

1) Create an Oracle Object Type in oracle database.

2) Create the Body for the Oracle Object Type in oracle database.

3) Create a oracle table that hold the objects in a table.

4) Insert data into the above created table using the PLSQL code.

5) Create a Java wrapper class using the Oracle JPublisher using the below command. jpub -user=USERNAME/PASSWORD -methods=none -builtintypes=jdbc -numbertypes=objectjdbc -usertypes=jdbc -sql address:Address:MyAddress -package=sample.jpubs THis will create a Java Interface class called MyAddress. This class belongs to the object Sample.jpub

Related Questions