How can i get the return variables of GET method in PL/SQL procedure

What are you going to do with the results?

Are all the variables for the "same column"?

Or is the result the equivalent to "one row with 10 columns"?

MK

Calling a REST service from a SELECT statement for each row in the SELECT statement is a good way to get yourself BLACKLISTED.

Quick setup for using it in PL/SQL

create or replacepackage test_pkgas  -- make this match your data  type rest_result_t is record (    col1  varchar2(10),    col2  varchar2(6),    col3  int );      function getInfoUser(id IN NUMBER) return rest_result_t;end;/create or replacepackage body test_pkgas      function getInfoUser(id IN NUMBER) return rest_result_t  as    l_buffer rest_result_t;  begin    -- make call to REST here        -- extract the results here    l_buffer.col1 := 'Hello';    l_buffer.col2 := 'World';    l_buffer.col3 := id;        return l_buffer;  end;end;/-- example usageset serveroutput on;declare  l_buffer  test_pkg.rest_result_t;begin  l_buffer := test_pkg.getInfoUser(round( dbms_random.value(1,10)) );    dbms_output.put_line( 'First Name = ' || l_buffer.col1 );  dbms_output.put_line( 'Last Name = ' || l_buffer.col2 );  dbms_output.put_line( 'Person''s ID =' || l_buffer.col3 );end;/

Hi,

I think with the level of detail you provided so far the best possible advice you could be given is "do it right".

If you want to get more reasonable responses that could be eventually helpful, you'll need to reveal some more secrets of that "particular service" and ideally your getInfoUser procedure as well.

Regards,

Pavel

Ok, that's a start, but not quite enough. You will get your best answer by:

1. Providing an example of the data package returned by the GET. You can always substitute dummy data for real data, but getting the structure and data types correct is essential. You can use cURL to do this or something like Postman (https://www.getpostman.com/). Postman is a little more involved, but once you understand it, it's great for tinkering around with services.

2. If the web service you are using is public, and it doesn't violate a confidentiality agreement to do so, post a link to its API documentation and the specific endpoint you are using. For example, here is a link to the Stripe API documentation: https://stripe.com/docs/api. And, here is a link to the "Create a Plan" endpoint: https://stripe.com/docs/api#create_plan.

Edit to add the following:

Have you successfully accessed the web service from PL/SQL? Or, do you need to know, from the beginning, how to make a REST call and handle the result? I think the assumption by everyone so far is that you are already able to call the service but are not sure how to parse the XML or JSON.

-Tom