DECLARE 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) := '{"items":{ "EMAIL_ID": "'||P_EMAIL_ID||'","CC_MAIL":"'||P_CC_MAIL||'"}}'; -- to invoke json , Directly pass Json in parameter value. htp.p(l_parm_values(1)); -- Get the XML response from... Read more
How to push data in body payload using ORACLE REST APIs? Working with ORACLE REST is really enjoyable and easy, of course. But if you have huge amount of data to push through the web service then it becomes hectic... Read more
BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: APEX_WEB_SERVICE.BLOB2CLOBBASE64 ( p_blob IN BLOB) RETURN CLOB; Example : declare l_clob CLOB; l_blob BLOB; begin SELECT BLOB_CONTENT INTO l_BLOB FROM APEX_APPLICATION_FILES WHERE name = :P1_FILE_NAME; l_CLOB := apex_web_service.blob2clobbase64(l_BLOB);... Read more
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 INTO l_BLOB FROM APEX_APPLICATION_FILES WHERE filename = 'APEX_ENHANCED_LOV_ITEM.plb'; -- Blob... Read more