Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

make_rest_request is letting unescaped request parameters in 23.2

vasstergNov 21 2023 — edited Nov 21 2023

APEX 23.2 apex_web_service.make_rest_request is now letting unescaped request call parameters for GET. Broke previous implementation of utf8 parameters and needed rewrite with explicit utl_url.escape. For example the below snippet was working fine with 23.1.5 but not with 23.2 (needed rewrite to pass the query string params as body with escaped paramutf8):

declare
v_result CLOB;
begin
v_result :=
apex_web_service.make_rest_request (
p_url => 'http://example.com/resource',
p_http_method => 'GET',
p_parm_name => apex_string.string_to_table ('param1:paramutf8'),
p_parm_value => apex_string.string_to_table ('12345' || ':' || 'ΑΒΓΔΕΗΘ'));
end;

This post has been answered by Carsten Czarski-Oracle on Nov 24 2023
Jump to Answer
Comments
Post Details
Added on Nov 21 2023
7 comments
606 views