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

BLOB to CLOB using APEX_WEB_SERVICE

BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: Copy CodeCopiedUse a different BrowserAPEX_WEB_SERVICE.BLOB2CLOBBASE64 ( p_blob IN BLOB) RETURN CLOB; Example : Copy CodeCopiedUse a different Browserdeclare…
February 29, 2020
Posted inAPEX

Clob to Blob Using APEX Web Service

CLOBBASE642BLOB Function This function is used to convert Clob to base64Blob. Syntax APEX_WEB_SERVICE.CLOBBASE642BLOB ( p_clob IN CLOB) RETURN BLOB; Example declare l_clob CLOB; l_blob BLOB; l_blob_2 BLOB; begin SELECT BLOB_CONTENT…
February 29, 2020