Hi ,
Thanks for your prompt help and very greatful.
But I have query, how I can pass 'l_request_blob' generated from below codes:
l_request_blob := apex_web_service.generate_request_body (
p_multipart => l_multipart );
to below procedure ' apex_web_service.make_rest_request' , that is,in which parameter of this procedure.
I am confused as l_request_blob in BLOB type
APEX_WEB_SERVICE.MAKE_REST_REQUEST(
p_url IN VARCHAR2,
p_http_method IN VARCHAR2,
p_username IN VARCHAR2 DEFAULT NULL,
p_password IN VARCHAR2 DEFAULT NULL,
p_scheme IN VARCHAR2 DEFAULT 'Basic',
p_proxy_override IN VARCHAR2 DEFAULT NULL,
p_transfer_timeout IN NUMBER DEFAULT 180,
p_body IN CLOB DEFAULT EMPTY_CLOB(),
p_body_blob IN BLOB DEFAULT EMPTY_BLOB(),
p_parm_name IN apex_application_global.VC_ARR2 DEFAULT empty_vc_arr,
p_parm_value IN apex_application_global.VC_ARR2 DEFAULT empty_vc_arr,
p_wallet_path IN VARCHAR2 DEFAULT NULL,
p_wallet_pwd IN VARCHAR2 DEFAULT NULL,
p_https_host IN VARCHAR2 DEFAULT NULL,
p_credential_static_id IN VARCHAR2 DEFAULT NULL,
p_token_url IN VARCHAR2 DEFAULT NULL )
RETURN CLOB;
Note : l_multipart is combination of json and attachment
Thanks in advance for your support
Regards,
Ritu