Oracle Forms to Oracle APEX Migration (Help)

1) Get API URL From Register WhatsApp API Provider 2) In my case https://app.chat-api.com/ 3) Login with your account or register for new account  4) Add new Instance  5) Give Instance Name and Reboot  6) Open your WhatsApp in mobile --> Go to Setting --> WhatsApp Web/Desktop  and Scan QR code for Activate your business account with instance  7) Copy Your API  8) Go to Oracle APEX , go to sql Workshop and create procedure to call the API 8 ) Call the procedure      Mobile No = Should Start with Country Code       begin     whatsapp_send (                                   l_mobileno => '968XXXXX',                                   l_message => 'Hello'            ...

  1. Execute the following command from SQL Plus as the SYS user:  Conn sys/Pass@xe as sysdba  (connect as container if 12c then  ALTER SESSION SET container = CDB$ROOT;) Alter user ords_public_user identified by xxxx; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; Connect as PDB Conn sys/Pass@xepdb1 as sysdba (if 12c  ALTER SESSION SET container = PDB1;) Alter user APEX_PUBLIC_USER identified by xxxx; Alter user APEX_REST_PUBLIC_USER identified by xxxx; Alter user APEX_LISTENER identified by xxxx; 2. Unlock the users: ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_LISTENER ACCOUNT UNLOCK; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; 3. Now create a profile for the APEX related users: Create profile apex_public_profile limit password_life_time unlimited; 4. Assign the profile to the APEX users: alter user apex_public_user profile apex_public_profile; alter user apex_rest_public_user profile apex_public_pr...

 How to store the selected Rows Column value into Array in Interactive Grid   In Oracle Forms we performed the following coding  /*GO_BLOCK ('TEST'); First_record ; While system.last_Record <> true  loop     if :test.status ='Y' then      :Master.Nbt_Sel :=:Master. Nbt_Sel + :test.docno ;     end if; next_Record; end loop;*/ How to achieve in Oracle APEX Interactive GRID Create Download button grid --> DA--Java Script  function Download()    {   var widget = apex.region("POR01").widget();   var grid = widget.interactiveGrid("getCurrentView");   var model = grid.model;   var selectedRecords = grid.getSelectedRecords();    var selRecords = {   "rows": []   };   var selRecordsJSON;       if (selectedRecords.length > 0)        {          if (confirm("Do you want to update comm...

how to update the record of Selected row in Interactive Grid ,  In Oracle Forms :- its very easy to achieve the below functionality with help of  /*GO_BLOCK ('TEST'); First_record ; While system.last_Record <> true  loop     if :test.status ='Y' then      update statement      end if; next_Record; end loop;*/ Now see in APEX Interactive GRID Create Update Button on GRID Region --> Create DA with JavaScript Code     var i, records, record, sal, model,         view = apex.region("emp").widget().interactiveGrid("getCurrentView");     if ( view.supports.edit ) { // make sure this is the editable view             percent = percent / 100;         model = view.model;         records = view.getSelectedRecords();  if ( records.length > 0 ) {             for ( i = 0; i < records...