Signaling BPM process from PL/SQL

Question

I am fairly new to BPM world. So i might miss basic parts of the topic, so forgive me if I do so.

What I need to do is , trigger/signal/request ( I don't know the best verb:) ) a BPM process from PL/SQL code. So my broadest guess is, this should be over an http request, most probably a web service request.

I use jBPM as my BPM engine, but it is not a must, I can use any option which is easier to work on my scenario.

Any advice on where to start.

Answer 1

You may also look into UTL_DBWS, an Oracle utility package for calling (or creating) web services.

Look HERE and HERE for an example of its use.

Another possibility is to create an external procedure (Java perhaps) and handle the call details there.

Finally, if the service is a more old school tcp service (probably not), look at utl_tcp (I've used this with success in projects in the past, but not as easy to use as calling an xml service, and some security issues to workthrough)