Geek asks and answers

BPM process signaling from PL / SQL

I am new to the world of BPM. Therefore, I can skip the main parts of the topic, so forgive me if I do this.

What I need to do is trigger / signal / query (I don’t know the best verb :)) BPM process from PL / SQL code. Therefore, as I understand it, this should be due to an HTTP request, most likely to a web service request.

I use jBPM as my BPM engine, but this is not a required parameter, I can use any option that is easier to work in my script.

Any tips on where to start.

+3
source share
2 answers

You can also see UTL_DBWS, the Oracle utility package for invoking (or creating) web services.

.

- (, Java) .

, tcp (, ), utl_tcp ( , , xml, )

+2

UTL_HTTP HTTP- PL/SQL. :

declare
    v_request UTL_HTTP.REQ;
    v_response UTL_HTTP.RESP;
    v_value VARCHAR2(1024);
begin
    v_request := UTL_HTTP.BEGIN_REQUEST('http://my.hostname.com/wsendpoint');
    v_response := UTL_HTTP.GET_RESPONSE(v_req);
    LOOP
        UTL_HTTP.READ_LINE(v_response, v_value, TRUE);
        DQMS_OUTPUT.PUT_LINE(v_value);
    END LOOP;
    UTL_HTTP.END_RESPONSE(resp);
end;

: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_http.htm

+1

More articles:


All Articles