Remote procedure call via DBMS_PIPE/AQ/whatever

I am building an application which needs to initiate a background process and 
receive its result. This is effectively a remote procedure call from one 
database session to another.

I have the application working using DBMS_PIPE - my "background" application 
runs as a Windows service, watching a pipe for requests, and processing them 
when they arrive then returning a result. The "main" application sends a 
request, plus a pipe name to use for the result, down the request pipe, then 
polls the result pipe to determine when the server has completed the request.

This works OK, but I've had to write a lot of fiddly code to manage request and 
response pipes, handle errors, etc. It feels like I'm reinventing a wheel here. 
I've also looked at the AQ documentation, but that also seems to focus on 
broadcast-style communication, rather than request/response interaction.

Have I missed anything? With internet service applications, there are a lot of 
options for remote requests (XML-RPC, SOAP) and I'm a little surprised that 
there isn't anything similar in Oracle (actually, if it helped, I could quite 
happily rewrite my "server" as an XML-RPC server, and use XML-RPC client code 
from the database, if such a thing existed...)

Any suggestions? Or should I just stick with my home-built solution?

Thanks,
Paul Moore.


__________________________________________________________________________
This e-mail and the documents attached are confidential and intended 
solely for the addressee; it may also be privileged. If you receive this 
e-mail in error, please notify the sender immediately and destroy it.
As its integrity cannot be secured on the Internet, the Atos Origin group 
liability cannot be triggered for the message content. Although the 
sender endeavours to maintain a computer virus-free network, the sender 
does not warrant that this transmission is virus-free and will not be 
liable for any damages resulting from any virus transmitted.
__________________________________________________________________________
--
http://www.freelists.org/webpage/oracle-l

Other related posts: