Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling a Java Webservice using PLSQL in Oracle

Tanzeel MirzaApr 2 2015 — edited Apr 20 2015

Hello Experts

Greetings of the day!!

We are working on one reuirement in which we have to call a Java based webservice (it is in SOA environment) from EBS PLSQL environment to get the response based on certain input parameters.

This webservice is password protected, below are the challenges that we have been facing:

1) We are not able to set the username and password needed to connect to the service when called from PLSQL.

2) Even if we connect to the webservice, there is a challenge to store the response of the Webservice.

If any one has ever faced any such requirement or has got idea of how to implement, please let us know.

Any idea will be highly appreciated.

Thanks

Mirza Tanzeel

This post has been answered by AlbertoFaenza on Apr 20 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2015
Added on Apr 2 2015
30 comments
6,903 views