oracle apex rest api

Solutions on MaxInterview for oracle apex rest api by the best coders in the world

showing results for - "oracle apex rest api"
Fynn
22 Jul 2016
1CREATE OR REPLACE FUNCTION add_numbers (p_int_1  IN  NUMBER,
2                                        p_int_2  IN  NUMBER)
3  RETURN NUMBER
4AS
5  l_clob    CLOB;
6  l_result  VARCHAR2(32767);
7BEGIN
8
9  -- Get the XML response from the web service.
10  l_clob := APEX_WEB_SERVICE.make_rest_request(
11    p_url         => 'http://oracle-base.com/webservices/add-numbers.php',
12    p_http_method => 'GET',
13    p_parm_name   => APEX_UTIL.string_to_table('p_int_1:p_int_2'),
14    p_parm_value  => APEX_UTIL.string_to_table(p_int_1 || ':' || p_int_2)
15  );
16
17  -- Display the whole document returned.
18  DBMS_OUTPUT.put_line('l_clob=' || l_clob);
19
20  -- Pull out the specific value of interest.
21  l_result := APEX_WEB_SERVICE.parse_xml(
22    p_xml   => XMLTYPE(l_clob),
23    p_xpath => '//answer/number/text()'
24  );
25
26  DBMS_OUTPUT.put_line('l_result=' || l_result);
27
28  RETURN TO_NUMBER(l_result);
29END;
30/
queries leading to this page
oracle apex da apioracle apex create report using rest apihow to call rest api from oracle apexapex apioracle apex api referencecreate api oracle apexrest api for apexoracle apex get apioracle apex database apioracle apex cusone rest apiusing rest apis in oracle apexoracle apex 19 rest web service exampleoracle apex js apioracle apex rest apiapex restful services exampleoracle ords rest apioracle apex rest baseoracle apex api 27s apex rest apirestful services apexoracle apex rest api componentsoracle apex restful serviceshow to use a rest api in an interactive report oracle apexoracle apex dynamic restoracle apex consuming rest apioracle apex apioracle apex rest datasourcerest objects in oracle apexoracle apex restful service examplepost web api apex oracleoracle apex make restful apiconsume rest api in oracle apexoracle apex rest api architectureoracle apex rest api full guideoracle apex rest dataintegrating oracle apex application with rest api and oracle databaseoracle apex consume rest web serviceapi you can use in oracle apexoracle api apexfunction oracle apex for apioracle apex call apirest api in apexoracle apex call rest serviceoracle apex rest 22 data 22how to create rest api in oracle apexapi oracle apexoracle apex apiswhat is ords in oracle apex tutorialhow to add api in oracle apexoracle apex rest source operationconsume rest api in oracle apex jsonoracle apex web services configurationoracle apex custom rest apioracle apex rest api post exampleoracle apex rest api exampleoracle apex api 27s apex 5apex restful servicesoracle apex rest api get exampleoracle apex rest apis componentsoracle apex javascript apioracle apex rest put restful services in oracle apexoracle apex anilist apiwhich api can be used over oracle apex applicationrest api apex oracle apex report from rest web service exampleusing api in oracle apexhow to use apis in oracle apexoracle apex add apioracle apex rest apisusing an api in oracle apexoracle apex json apidynamic rest api display oracle apexoracle apex rest data sourceoracle apex application items apioracle apex call web apioracle apex datasource restrest enabled sql in oracle apexoracle apex rest api