Home » SQL & PL/SQL » SQL & PL/SQL » Calling an API from PL/SQL (Oracle 12c RDS)
Calling an API from PL/SQL [message #677745] Thu, 10 October 2019 13:15 Go to next message
Shiv93
Messages: 16
Registered: September 2019
Junior Member
Hi,
Can someone let me know how to connect an API from pl/SQL
I have an url for which I have to pass the input parameters from my procedure.

Please let me know if anyone aware of such scenarios.
Re: Calling an API from PL/SQL [message #677746 is a reply to message #677745] Thu, 10 October 2019 14:30 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What about feeding back and thanking people who helped you before posting a new question?

Re: Calling an API from PL/SQL [message #677880 is a reply to message #677746] Sat, 19 October 2019 13:28 Go to previous messageGo to next message
Shiv93
Messages: 16
Registered: September 2019
Junior Member
Hi all,
I was successfully able to call the API from plsql
. I hope this thread can be closed
Re: Calling an API from PL/SQL [message #677881 is a reply to message #677880] Sat, 19 October 2019 14:48 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

How?

Re: Calling an API from PL/SQL [message #677882 is a reply to message #677880] Sat, 19 October 2019 18:24 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
Sivachandran wrote on Sat, 19 October 2019 13:28
Hi all,
I was successfully able to call the API from plsql
. I hope this thread can be closed
So give back to the community by telling how you solved it.

There is no concept of 'closing' a thread on this torum.
Re: Calling an API from PL/SQL [message #677883 is a reply to message #677882] Sun, 20 October 2019 03:30 Go to previous message
Shiv93
Messages: 16
Registered: September 2019
Junior Member
Hey Everyone,

Sorry for the delayed response.

I was succeessfully able to call the API by following the below link.It provided a step by step proceess need to be followed. I hope this helps you folks as well.

https://technology.amis.nl/2015/05/11/invoke-a-rest-service-from-plsql-make-an-http-post-request-using-utl_http-in-oracle-database-11 g-xe/
Previous Topic: Rows into Columns (2 merged)
Next Topic: Interval Partition table on Date column with SYSDATE as value (merged)
Goto Forum:
  


Current Time: Sat Dec 07 04:22:20 CST 2019