[Oracle]오라클에서 트리거로 웹가져오기(?)
오라클에서 트리거로 웹가져오기(?) create or replace TRIGGER TEST_TABLE_TRIGGER AFTER INSERT OR UPDATE OF NAME ON TEST_TABLE for each row DECLARE req utl_http.req; res utl_http.resp; value VARCHAR2(4000); BEGIN SELECT UTL_HTTP.REQUEST('http://10.10.11.18:5051/api/status/ping') INTO value FROM DUAL; EXCEPTION WHEN UTL_HTTP.END_OF_BODY THEN UTL_HTTP.END_RESPONSE(res); WHEN OTHERS THEN RAISE_APPLICATION_ERROR ( -..
2022.06.14