الاثنين، 26 سبتمبر 2022

How to Solve Ords Issue : The request could not be mapped to any database.

 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






this issue because the PDB in not Open 
Login as sysbda
and run 
alter pluggable database all open;





then
Stop ORDS App from tomcat and start it again 


Ords will work Fine Now







الأربعاء، 15 يونيو 2022

how to expand navigation menu by default in oracle APEX

how to expand navigation menu by default  in oracle APEX 
Ceate Dyanmic Action on Page  
event : Page Load 
action : Execute Server-side Code

$("#t_PageBody").removeClass("js-navCollapsed"); 
$("#t_PageBody").addClass("js-navExpanded"); 
$("#t_Button_navControl").addClass("is-active"); 
$("#t_Button_navControl").attr("aria-expanded","true");

 


الاثنين، 13 ديسمبر 2021

Create an APEX Application Using RESTful service

 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.



Choose Shared Components > 
REST Data Sources





Add the name and URL for your empall module created earlier, click next



The next step will automatically split up the endpoint URL into a server-specific
and a service-specific part. Click Next



For authentication select No, click Discover


Employees from the emps table will be discovered. Click Create Web Source.

Return to the application  and click the Create Page button in order to add a new page. 


Choose Classic Report.


For Data Source, choose Web Source, select the Apex Restful Service service. Click Create.

The employees in the database table emp are displayed in the application
 using the REST Web Service.








Deleting Data Using RESTful Service

  Deleting  Data Using RESTful Service


 you will create a RESTful Service to delete data using the HTTP Method DELETE. 

In the emp/:empidTemplate, create a new DELETE Handler.
Specify the DELETE Method, and Source Type as PL/SQL. 
 Provide the Source Code for the PL/SQL.









BEGIN
    DELETE 
    FROM EMP 
    WHERE EMPNO = :empid;
    htp.prn('employee '|| :empid || ' Deleted');
END;

To test in Postman, click the plus icon to create a new tab.

Select DELETE, enter the correct URL adding /124.
 Click the Params tab. For KEY enter Content-Type, and for VALUE enter application/json
 

 



 Click Send.If the delete was successful, you will see the message below.




الخميس، 9 ديسمبر 2021

Updating 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






BEGIN
UPDATE EMP  
Set  SAL = SAL*2 
WHERE EMPNO= :empid;
htp.prn('Updated');
END;

Test in Postman, select PUT, enter the correct URL adding /124, click the Body tab,
 check raw, 
 Click Send.If the update was successful, you will see the message below.

 



Inserting Data Using RESTful Service

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.



BEGIN
INSERT 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.  



In the postman tool to test the POST request, click the Body tab, 
check raw, and enter the json code shown below. Click Send

{"EMPNO":124, "ENAME":"testinsert", "JOB":"IT_MANA", "MGR":7902, "HIREDATE":"25-JUN-15", "SAL":11, "COMM":22, "DEPTNO":10}



If the insert is successful, you will see the message below.

Check the new inserted record informationby using the GET handler created in the previous section, adding 124 to the end of the URL.

http://localhost:8080/ords/re/EMP_TEST/emp/124



 thanks

Creating Restful Web Service to Retrieving Data Using a Parameter

 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.





Add the Source code for the GET Handler. 





Test the new Web service from the Browser, 
adding a valid employee number to the end of the URL for your schema.
 7839 is the empno for “King”.
http://localhost:8080/ords/re/EMP_TEST/emp/7839


Test the new Web service from postman.




Creating the first Restful Web Service [ will retrieve all records in the emp table ]

 Creating the first Restful Web Service

The first Restful Web service will retrieve all records in the emp table.

Click Create Module button.



Provide the Module Name oa_test, and the Base Path /EMP_TEST/.

Change Paginationsize to 25.




Click “Create Module”

Click “Create Template”.

Create the Resource Template empall/.

Create the Resource Handler.
Click “Create Handler”


Create the Resource Handler.
Enter the following query in the “Source” area:
SELECT * FROM emp
Click “Create Handler

Copy the module URL.
Ensure the GET Resource Handler is selected,
and click the icon to copy the URL.

Test the Rest Web Service from the web browser.

Select GET, paste the URL,
and click Send to test the Rest Web Service from Postman.



Using RESTful Web Services in Oracle Application Express(APEX) 2 [ Register Schema with ORDS From Sql Developer]

  Register Schema with ORDS From Sql Developer

Open sql developer and open connection for your schema

your Sceham not registerd for ORDS Yet



Right Click on your connection > Rest Service > Enable Rest Service 




Click Enable Rest Service 

choose Your schema alias 

Press NEXT





You can see Code from SQl Tab 


Press Finish

we will find that our schema is register with ORDS


We can Use the Code Direct in SQL Developer 

DECLARE
  PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN

    ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
                       p_schema => 'RE',
                       p_url_mapping_type => 'BASE_PATH',
                       p_url_mapping_pattern => 're',
                       p_auto_rest_auth => FALSE);

    commit;

END;

----
thanks







الأربعاء، 8 ديسمبر 2021

Using RESTful Web Services in Oracle Application Express(APEX) 2 [ Register Schema with ORDS From APEX ]

Register Schema with ORDS From APEX

Login into Oracle Application Express (APEX).



On the Workspace home page, click SQL Workshop.


Click RESTful Services. RESTful Services


If your schema is not registered with ORDS RESTful Data Services, 

click Register Schema with ORDS



ORDS Schema Attributes dialog (Note: your schema name will be different). 

Click Save Schema Attributes.



ORDS RESTful Services dashboard:






How to Solve Ords Issue : The request could not be mapped to any database.

 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...