Posted inAPEX

Strip html using PLSQL

Referred from John’s cookbook sample app. Copy CodeCopiedUse a different Browsercreate or replace function striphtml( p_html in varchar2) return varchar2 is l_html varchar2(32767); l_pos pls_integer; begin if length(p_html) > 0 then l_html…
October 7, 2021
Posted inAPEX IG Interactive Grid

Interactive GRID | Hide Report Settings Area

Referred from John’s cookbook sample app. Interactive GRID Attributes Advanced JavaScript Initialization Code Copy CodeCopiedUse a different Browserfunction(config) { config.reportSettingsArea = false; apex.util.getNestedObject(config, "views.grid.features").highlight = false; return config; }
October 6, 2021
Posted inAPEX Interactive Grid

Interactive GRID | Rows Per Page on Toolbar

Referred from John’s cookbook sample app. Interactive GRID Attributes Advanced JavaScript Initialization Code Copy CodeCopiedUse a different Browserfunction(config) { var $ = apex.jQuery, toolbarData = $.apex.interactiveGrid.copyDefaultToolbar(), toolbarGroup = toolbarData.toolbarFind("actions1"); toolbarGroup.controls.unshift( { type:…
October 6, 2021
Posted inAPEX JavaScript

Get Device ID in Oracle APEX

How to Get Device ID in Oracle APEX? Create a page with a page item and paste below Javascript in Function and Global Variable Declaration section as per screenshots. Copy CodeCopiedUse a…
October 1, 2021
Invoke Web Services using APEX_WEB_SERVICE in Oracle APEX
Posted inAPEX

Invoke Web Services using APEX_WEB_SERVICE in Oracle APEX

Directly pass the JSON in parameter value. Copy CodeCopiedUse a different BrowserDECLARE l_parm_names apex_application_global.vc_arr2; l_parm_values apex_application_global.vc_arr2; l_clob CLOB; P_EMAIL_ID varchar2(100):='ashishk392@gmail.com'; P_CC_MAIL varchar2(100):='vikaspandey641@gmail.com'; BEGIN l_parm_names (1) := 'input'; l_parm_values (1) :=…
September 29, 2021
Posted inAPEX

APEX_JSON.WRITE_RAW

Referred from Oracle Standard Document. APEX_JSON write unescaped JSON write an unescaped array attribute. use the escaping write() procedures instead, if possible. PARAMETERS p_value The value to be written which can…
September 25, 2021