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