OraFAQ Forum: SQL & PL/SQL » Calling an API from PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Calling an API from PL/SQL (Oracle 12c RDS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calling an API from PL/SQL [message #677745]

Thu, 10 October 2019 13:15

Shiv93
Messages: 34
Registered: September 2019

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.

Report message to a moderator

Re: Calling an API from PL/SQL [message #677746 is a reply to message #677745]

Thu, 10 October 2019 14:30

Michel Cadot
Messages: 67666
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?

Report message to a moderator

Re: Calling an API from PL/SQL [message #677880 is a reply to message #677746]

Sat, 19 October 2019 13:28

Shiv93
Messages: 34
Registered: September 2019

Member

Hi all,
I was successfully able to call the API from plsql
. I hope this thread can be closed

Report message to a moderator

Re: Calling an API from PL/SQL [message #677881 is a reply to message #677880]

Sat, 19 October 2019 14:48

Michel Cadot
Messages: 67666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How?

Report message to a moderator

Re: Calling an API from PL/SQL [message #677882 is a reply to message #677880]

Sat, 19 October 2019 18:24

EdStevens
Messages: 1293
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.

Report message to a moderator

Re: Calling an API from PL/SQL [message #677883 is a reply to message #677882]

Sun, 20 October 2019 03:30

Shiv93
Messages: 34
Registered: September 2019

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/

Report message to a moderator

Previous Topic:	Syhthesizing
Next Topic:	Interval Partition table on Date column with SYSDATE as value (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 26 10:22:46 CST 2021