User0911
User0911

Reputation: 1582

PL/SQL Procedure to call a Restful Web Service and update DB table

I need a PL/SQL block that will call a restful web service. For example

http://localhost:8080/SampleApp/fetchEmployeeData

This Procedure will be scheduled to run every 5 minutes, and I want to call another web service every time this PL/SQL block runs and pass the job running time to that web service.

I can't find any example to call a restful web service on net. This example is not working for me. Access Web service from Oracle stored procedure

Any help will be appreciated.

Upvotes: 1

Views: 8899

Answers (1)

Osy
Osy

Reputation: 1633

An Oracle way is using Oracle REST Data Services

Check Accessing the RESTful Services from a Third Party Application chapter.

Upvotes: 2

Related Questions