Forum Stats

  • 3,769,977 Users
  • 2,253,041 Discussions
  • 7,875,257 Comments

Discussions

Query regarding apex_web_service.generate_request_body

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