The request could not be mapped to any database.
Check the request URL is correct, and that URL to database mappings have been correctly configured
Blog for Oracle apex in Arabic
The request could not be mapped to any database.
Check the request URL is correct, and that URL to database mappings have been correctly configured
Create an APEX Application Using RESTful service
In this section, you will create a simple application using the Application Builder component of APEX to display the employees in the emps table.
Click the Oracle logo to go to the APEX home page, then click App Builder
Create a simple application with home page. Click Create, Create a New App
Create the EMP DISPLAY application.
Add the name: EMP DISPLAY, accept all other default values and click Create application.
Deleting Data Using RESTful Service
Updating Data Using RESTful Service
In this section, you will create a RESTful Service to update data using the HTTP Method PUT.
You will use the postman tool to test your RESTful Service,
and to verify the results
Specify the PUT Method and Source Type as PL/SQL.
Provide the Source Code for the PL/SQL
Inserting Data Using RESTful Service
you will create a RESTful Service to insert data using the HTTP Method POST.
You will use the postman tool to test your RESTful Service and to verify the results.
In the empall Template, create a new POST Handler.
BEGININSERT INTO EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(:EMPNO,:ENAME,:JOB,:MGR,TO_DATE(:HIREDATE,'DD-MON-RR'),:SAL,:COMM,:DEPTNO);htp.prn('employee '|| :EMPNO);END;
In the postman tool to test the POST request, we have to set the Content-type to application/json.
Click the Headers tab under the URL bar.
Under the heading KEY, enter Content-Type, and for VALUE enter application/json.
Retrieving Data Using a Parameter
Perform the following steps to create a RESTful Service which retrieves the employee information based on a parameter id using the HTTP Method GET.
In the EMP_TEST module, create a new Template emp/:empid following the steps shown in the previous section.
Creating the first Restful Web Service
The first Restful Web service will retrieve all records in the emp table.
Click Create Module button.
Register Schema with ORDS From Sql Developer
Open sql developer and open connection for your schema
your Sceham not registerd for ORDS Yet
Click Enable Rest Service
choose Your schema alias
Press NEXT
Press Finish
we will find that our schema is register with ORDS
click Register Schema with ORDS
ORDS Schema Attributes dialog (Note: your schema name will be different).
Click Save Schema Attributes.
The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly c...