Oracle Forms to Oracle APEX Migration (Help)

Use SQLcl to Display ORDS Web Service Definitions useful link https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-create-basic-rest-web-services-using-plsql https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-use-sqlcl-to-display-ords-web-service-definitions ============================================================================================================= Basic Information (schemas, modules, privileges) ('Module --> Template --> Handler') ============================================================================================================= => Schema CONN sys/OraPassword1@pdb1 AS SYSDBA Connected. SQL> REST schemas PARSING_SCHEMA PATTERN STATUS -------------- ------- ------- TESTUSER1      hr      ENABLED => Module SQL> CONN testuser1/testuser1@pdb1 Connected. SQL> REST modules NAME    PREFIX    STATUS    ITEMS_PER_PAGE ------- -...

Apex Installation & Deployement  (Oracle 18c , Apex 20.1 , ORDS 19.0 , Tomacat 9.0) https://oracle-base.com/articles/misc/oracle-application-express-apex-installation https://www.aflorestorres.com/2019/03/install-oracle-database-18c-express-and.html https://matthiashoys.wordpress.com/2019/12/12/installation-of-apex-19-2-on-oracle-18c-xe-express-edition/ Web Logic Configuration  http://info.aimstar.com/blog/deploying-ords-on-weblogic-for-apex 1)Download the APEX software. https://www.oracle.com/tools/downloads/apex-downloads.html 2)Create a new tablespace to act as the default tablespace for APEX. (Optional) -- For Oracle Managed Files (OMF). CREATE TABLESPACE apex DATAFILE SIZE 100M AUTOEXTEND ON NEXT 1M; -- For non-OMF. CREATE TABLESPACE apex DATAFILE '/path/to/datafiles/apex01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M; 3)Installation Change directory to the directory holding the unzipped APEX software. Unzip downlaoded file and past in Oracle Home Directory like...

ACL Error 1) Granting Connect Privileges Prior to Oracle Database 12c Demonstrates how to grant connect privileges to any host for the APEX_200100 database user. The following example demonstrates how to grant connect privileges to any host for the APEX_200100 database user. This example assumes you connected to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. DECLARE   ACL_PATH  VARCHAR2(4000); BEGIN   -- Look for the ACL currently assigned to '*' and give APEX_200100   -- the "connect" privilege if APEX_200100 does not have the privilege yet.     SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS    WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;     IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_200100',      'connect') IS NULL THEN       DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,     ...

1) Create a dynamic action on "selection change (interactive grid)" The true action is "execute javascript code" //set the static id field on your interactive grid and put the value on gridID variable var gridID = "dept"; var ig$ = apex.region(gridID).widget(); var grid = ig$.interactiveGrid("getViews","grid"); var selectedRecord = grid.getSelectedRecords(); console.log(selectedRecord); localStorage.setItem('lastSelectedRecord', JSON.stringify(selectedRecord)); 2 - Create a dynamic action on "page load" //set the static id field on your interactive grid and put the value on gridID variable var gridID = "dept"; var ig$ = apex.region(gridID).widget(); var grid = ig$.interactiveGrid("getViews","grid"); grid.setSelectedRecords(JSON.parse(localStorage.getItem('lastSelectedRecord')));

Oracle APEX hide the x on the modal dialog var button = parent.$('.ui-dialog-titlebar-close'); //get the button button.hide(); //hide the button Hide Title  Execute when Page Loads  $(".ui-dialog-titlebar").hide() ;  $("#youTubeVideoPlayer .ui-dialog-titlebar").hide();  Close Modal  closeModal('SUPINV');

conn sys/manager1@cispdb as sysdba  SELECT DBMS_XDB.GETHTTPPORT FROM DUAL; EXEC DBMS_XDB.SETHTTPPORT(8080); SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

useful url https://community.oracle.com/thread/4323510 https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/MAKE_REST_REQUEST-Function.html#GUID-C77BB45A-8968-470C-8243-BADB63743DE9 https://oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services https://oracle-base.com/articles/misc/xmltable-convert-xml-data-into-rows-and-columns-using-sql https://stackoverflow.com/questions/34786699/select-and-update-oracle-blob-column-with-xmlquery https://oracle-base.com/articles/misc/xmltable-convert-xml-data-into-rows-and-columns-using-sql useful url https://community.oracle.com/thread/4323510 https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/MAKE_REST_REQUEST-Function.html#GUID-C77BB45A-8968-470C-8243-BADB63743DE9 https://oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services https://oracle-base.com/articles/misc/xmltable-convert-xml-data-into-rows-and-columns-using-sql h...

Wallet Creation Sucess Step https://www.youtube.com/watch?v=mIkBXhaeO70 https://oracle-base.com/articles/linux/create-self-signed-ssl-certificates https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-and-tls-for-database-connections https://docs.oracle.com/cd/E23943_01/core.1111/e10105/walletmgr.htm#ASADM10184 Securing Credentials Using Wallet https://www.youtube.com/watch?v=dF5Zas1i-W8 1) Give ACL rights Conn sys/Manager1@cispdb BEGIN     DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(         host => '*',         ace => xs$ace_type(privilege_list => xs$name_list('connect'),                            principal_name => 'BLZLIVE',                            principal_type => xs_acl.ptype_db)); END; 2) Create Wallet folder in desired folder T...