Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Uday.

Asked: August 13, 2020 - 1:15 am UTC

Last updated: August 13, 2020 - 3:55 am UTC

Version: 11GR2

Viewed 1000+ times

You Asked

Hi Tom,

We are using utl_http in our PLSQL code to communicate with external system.
We are using POST method to send message to external system and with certain transfer timeout we are waiting for response and reading the response.

Now we are planning to remove or take away utl_http from code.
As this is synchronous communication, can you advise the possible ways which substitute utl_http.


Thank You.

and Connor said...

Now we are planning to remove or take away utl_http from code.


The obvious question is why?

If you not doing it from the database, then you'll probably look at hooking into ORDS to do this from your middle tier app code.

https://www.oracle.com/au/database/technologies/appdev/rest.html

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library