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, …

ORA-00972: identifier is too long

ORA-00972: identifier is too long. Till Oracle 12 C, the identifier length is 30 characters. Starting from 18 C Oracle increased the length of identifier to 128 character. So now we can define our identifiers till 128 characters if you have upgraded to 18 C. Let see one example. Database version 18 C. Select ename as …

APEX page types | Universal Theme

APEX provides three types of pages till APEX 20. To create these pages Select Page Mode. Page Mode Select the page mode for this page. Available options include: Normal The page is presented as a normal Application Express application page. Modal Dialog The page is presented as a modal dialog. A modal dialog is …

Blob to Clob Using DBMS_LOB

Create function to convert the blob content to clob CREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) RETURN CLOB AS l_chunk VARCHAR2 (32767); l_position PLS_INTEGER := 1; l_buffer_size PLS_INTEGER := 32767; l_clob_text CLOB; BEGIN -- Create temprary DBMS_LOB.createtemporary (l_clob_text, TRUE); FOR i …