oracle调用接口,Oracle行级触发器使用存储过程调用HTTP接口

CREATE OR REPLACE TRIGGER ON_INSERT_TRIGGER_500INDEX

AFTER  INSERT ON DA_L_PORT_FOR_500INDEX

FOR EACH ROW

BEGIN

POST_CHANGE_ITEM('DA_L_PORT_FOR_500INDEX','PFI_ID',:NEW.PFI_ID);

END;

CREATE OR REPLACE PROCEDURE POST_CHANGE_ITEM(v_table_name in varchar2,v_table_id in varchar2,v_id_value in varchar2 ) IS

req  UTL_HTTP.REQ;

resp UTL_HTTP.RESP;

v_message  varchar2(10000);

xmlstr  varchar2(30000);

v_content  varchar2(30000);

begin

begin

v_content := 'tableName='||v_table_name||'&idField='||v_table_id||'&idValue='||v_id_value;

req  := UTL_HTTP.BEGIN_REQUEST('http://172.16.164.6:8080/presap/da/dbc.do?'||v_content);

utl_http.set_header(req, 'Content-Type', 'text/html; charset=utf-8');

utl_http.write_text(req,xmlstr)