Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

create post API Restful service and call it by oracle apex application

SALEEM_YEMENJan 3 2024

declare
l_response_clob clob;
l_clob CLOB;
en varchar2(100);
sal number;
l_body varchar2(100);
BEGIN
en:=:P3_ENAME;sal:=:P3_SAL;
apex_web_service.g_request_headers(1).name := 'Content-Type';
apex_web_service.g_request_headers(1).value := 'application/x-www-form-urlencoded';
l_clob := apex_web_service.make_rest_request(
p_url => 'http://localhost:8080/ords/apex21c/admin/getnam',
p_http_method => 'POST',
p_parm_name => apex_util.string_to_table('ename:sal'),
p_parm_value => apex_util.string_to_table(''||en||':'||sal||''));
END;

Comments
Post Details