How to create RESTful in apex oracle

2
votes

Here is how I tried creating web service in apex oracle.

1st Step:

Creating RESTful services First got to SQL Workshop -> RESTful Services -> Create and fill the form.

enter image description here

2nd Step: Apply changes. enter image description here

3rd Step: Webservices References.

Got to Application Builder -> ApplicationName -> Shared Components ->WebServices References -> Create.

enter image description here

4th Step. Filled up the form enter image description here

5th Step : enter image description here

  1. 6th Step enter image description here

  2. 7th Step enter image description here

    8th Step enter image description here

    9th Step: Created enter image description here

    10th Step: Testing. But it shows an error. enter image description here

After all of the above steps, I was unable to call the webservice from my browser. Please help me in this matter.

1
oracleoracle-apex
Only steps 1-2 are needed. Steps 3-9 are for consuming a web service on a different server from Apex, and are irrelevant here. Try browsing to 192.168.0.44:7778/apex/SYMPSYS/testService - your URL from Step 2. – kfinity
Also on the page for step 2 there should be a "Test" button which will show you the correct URL. – kfinity

1 Answers

0
votes

Do you use ORDS with this schema? If you do something like

   ords.enable_schema(p_enabled               => TRUE,
                      p_schema                => user,
                      p_url_mapping_type      => 'BASE_PATH',
                      p_url_mapping_pattern   => some_path,
                      p_auto_rest_auth        => FALSE);

then default mapping in APEX can be changed to mapping from this call.