Skip to Main Content

Breadcrumb

Dev Live Dev Intro

We are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August and September. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, Uday.

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

Answered by: Connor McDonald - Last updated: August 13, 2020 - 3:55 am UTC

Category: PL/SQL - 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 we 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

More to Explore

PL/SQL

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