I have an urgent requirement , I need to write a stored procedure which makes an rest api call and it gets an 100's of inerts statement as output. My question is
how to use the UTL_HTTP package to make this call and get the output. Any help is really appreciated. I am not able to figure out should i use XML soap or json .