CREATE OR REPLACE PROCEDURE CLEAR_CACHE(p_status OUT VARCHAR2) IS
l_ws_response_clob CLOB;
l_ws_url VARCHAR2(500) := 'https://bitrial123-oracletrial123.analytics.us.oraclecloud.com/bimodeler/api/v1/dbcache';
BEGIN
apex_web_service.g_request_headers(1).name := 'X-ID-TENANT-NAME';
apex_web_service.g_request_headers(1).Value := 'usoracletrial123';
l_ws_response_clob := 
apex_web_service.make_rest_request
(
p_url => l_ws_url,
p_http_method => 'DELETE',
p_username => 'UserName',
p_password => 'Pwd'
);
p_status := apex_web_service.g_status_code;
dbms_output.put_line('Status:' || dbms_lob.substr(p_status));
END;


DECLARE
p_status VARCHAR2(500);
BEGIN
CLEAR_CACHE(p_status);
END;


CREATE OR REPLACE FUNCTION FUNC_CLEAR_CACHE (
p_input_value VARCHAR2
) RETURN VARCHAR2
IS PRAGMA AUTONOMOUS_TRANSACTION;
p_status VARCHAR2(500);
BEGIN
CLEAR_CACHE(p_status);
COMMIT;
RETURN p_status;
END;


SELECT FUNC_CLEAR_CACHE('Hello')
FROM DUAL;

CREATE TABLE DUMMY_REFRESH
(REFRESH_TEXT VARCHAR2(255));

INSERT INTO DUMMY_REFRESH (REFRESH_TEXT)

VALUES ('Dummy Table Used to Clear Cache');

Data Model:
EVALUATE('FUNC_CLEAR_CACHE(%1)','Hello')

CASE WHEN "DUMMY_REFRESH"."Run_Func" = '200' THEN 'Successful' ELSE 'Failed with Status: ' ||  "DUMMY_REFRESH"."Run_Func" END