APEX 20 First Look

APEX 20.1 First look Page Designer Updates User Profile Browse by Facets : This is gonna great interface for developers to manage all the application components. Available filters in facets “Search Application Pages” are below Page Type Template Build Option Authorization Created By Last Updated By …

Working With SYS_CONTEXT

How to create Oracle SYS_CONTEXT ? Oracle SYS_CONTEXT holds the value of the parameter associated with context namespace. Prerequisite Database user needs grant to create context. GRANT CREATE ANY CONTEXT TO c##ontoor_dev; Package to set parameter value. CREATE OR REPLACE PACKAGE sys_context_utility IS /* Version 1.0.1 …

Use of apex.server.process in async mode

How to use apex.server.process in async mode? apex.server.process namespace works in async mode, meaning whenever you hit the process it never waits to complete. Let’s take below example. AJAX process name : GET_EMP_DATA Description: This process bring data from ORDS REST API. function get_data(p_url, …