JDeveloper 11g – Creating PL/SQL Webservice and deploying to Weblogic Server

Feeds:: Posts; Comments

JDeveloper 11g – Creating PL/SQL Webservice and deploying to Weblogic Server

July 10, 2009 by oraclesoa

You can expose PL/SQL stored procedures as Webservice via JDeveloper(which wraps the PL/SQL code into Java wrapper), and you can deploy it into weblogic server.

1. Open JDev 11g and create a database connection to HR schema(a sample schema that contains the PL/SQL procedure).

2. Create a generic application PL_SQL_WS and project name GetEmployee.

3. From the database connnection navigator right click the PL/SQL package and publish as webservice. Click next and accept the default

4. Accpet the default and start once finished start the Weblogic Server, here im using the embedded weblogic server in the JDeveloper 11g.

5. Login into Weblogic console and create a datasource connection.

Name – hrconnDS
JNDI Name – jdbc/hrconnDS
Donforget to DS suffix.

6. Deploy the application to the Weblogic Server from JDeveloper11g.

7. Test the Webservice from Weblogic console, through the Weblogic test client.

Posted in Weblogic | 9 Comments

9 Responses

on July 30, 2009 at 12:33 PM | Reply Chandan

I want to learn this and find very interesting.
on August 21, 2009 at 12:13 AM | Reply oraclesoa

Hi Chandan, letme know if you need some help on this..
on September 11, 2009 at 9:01 PM | Reply Mauricio

Hi,

I was waiting this feature for a while. Do you know if this feature works fine if the database es Oracle 9i? Thanks.
- on September 22, 2009 at 3:56 PM | Reply oraclesoa
  
  Hi Mauricio,
  
  This sould work in Oracle DB 9i, even though in this example, I used 10g Database.
  
  Thanks,
  Arun
on September 18, 2009 at 6:29 PM | Reply Bhaskar

Hello,

I want to Publish the Webservice having complex structure say given a department code ( from dept table) the web service should send the employees (emp table) of the dapartment and qualifications ( emp_qualification table each emp may have more than one) of each employee as PL sql web service. I am only finding the examples like given emp code, send the salary. I am not able to get a example of complex one in PL sql. Is it possible to publish above said one?

Thanks
on October 18, 2009 at 4:58 PM | Reply MEDO

Thanks
please if it is posible send me VIDEO of jdeveloper 11g(jsp and jsf )
yours
on November 9, 2009 at 6:03 PM | Reply Bhaskar

Hello,

I could publish Web serivce of question raised by me on Sep 18th 2009 using Jdeveloper and oc4j.

Now I am looking for PL Sql procedure and/or JSP which will consume web service and store the consumed data into table(s).

Can I get any example for this type.

Thanks in advance.
on November 10, 2009 at 10:37 PM | Reply Carlos Pereira

Hi,

I’m new developing web services and using jdeveloper. I followed your tutorial and now i want to secure this web services requesting username and password. Can you help me out?

Thanks
on November 12, 2009 at 2:53 AM | Reply oraclesoa

Hi Carlos,

You can secure web service using a comprehensive tool like – Oracle Web services Manager (OWSM) – http://www.oracle.com/technology/products/webservices_manager/index.html

also check on – Securing Web Services using JDeveloper -

http://www.oracle.com/technology/products/jdev/101/howtos/securews/index.html

Thanks,
Arun