How to call Oracle SQL Query as a Web Service?

Asked By kris marky 0 points N/A Posted on - 11/14/2011

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.

 

 

 

• Status: Open
• Question Views: 2152
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by cevvavijay

Go To Solution

Answered By dean78 0 points N/A #105884

How to call Oracle SQL Query as a Web Service?

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.

About dean78

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/19/2011
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By cevvavijay 0 points N/A #105885

How to call Oracle SQL Query as a Web Service?

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

About cevvavijay

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 01/24/2012
• Question Category: Oracle Database