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
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
Posted inAPEX

Download files in APEX

Download files in APEX short code. Copy CodeCopiedUse a different Browserbegin sys.htp.init; sys.owa_util.mime_header( <MIME_TYPE>, FALSE ); sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( <BLOB_FILE>)); sys.htp.p('Content-Disposition: attachment; filename="' || <FILE_NAME> || '"' ); sys.htp.p('Cache-Control:…
September 23, 2021
Posted inAPEX

How to upload multiple files in APEX

Referred from Oracle APEX Page Designer Help . How to upload Multiple files in APEX? declare l_file_names apex_t_varchar2; l_file apex_application_temp_files%rowtype; begin l_file_names := apex_string.split ( p_str => :page item name, p_sep =>…
September 22, 2021