企业官网建设流程全解析

1.使用apifox工具调用接口如下

2.使用plsql调用该接口如下

DECLARE Req Utl_Http.Req; Resp Utl_Http.Resp; VALUE VARCHAR2(1024); v_Url VARCHAR2(200) := 'your url';-- URL to post to，调用的接口地址 -- Post Parameters --v_Param VARCHAR2(5000) := 'your parameter';--参数，需要发送的请求报文 v_Param VARCHAR2(5000) := 'input=[{"name":"测试1","delivery_date":"2024-03-06","detail":[{"id":"","name":"","qty":0,},{"id":"","name":"","qty":0,}]}]'; v_Param_Length NUMBER := Length(v_Param); BEGIN Req := Utl_Http.Begin_Request(Url => v_Url ,Method => 'POST'); /*Utl_Http.Set_Header(r => Req ,NAME => 'Content-Type' ,VALUE => 'multipart/form-data; charset=utf-8; boundary=/');*/ --这个格式的参数报文不好拼接，换成下面也能调用成功 Utl_Http.Set_Header(r => Req ,NAME => 'Content-Type' ,VALUE => 'application/x-www-form-urlencoded'); Utl_Http.Set_Header(r => Req ,NAME => 'Content-Length' ,VALUE => v_Param_Length); Utl_Http.Write_Text(r => Req ,Data => v_Param); Resp := Utl_Http.Get_Response(Req); Dbms_Output.Put_Line('Response Body:'); --拼接返回的报文 LOOP Utl_Http.Read_Line(Resp ,VALUE ,TRUE); Dbms_Output.Put_Line(VALUE); END LOOP; Utl_Http.End_Response(Resp); EXCEPTION WHEN Utl_Http.End_Of_Body THEN Utl_Http.End_Response(Resp); END;