From oracle-l-bounce@freelists.org Tue Dec 13 04:51:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jBDApjI2000956 for ; Tue, 13 Dec 2005 04:51:45 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jBDApeAX000931 for ; Tue, 13 Dec 2005 04:51:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A0707253A2E; Tue, 13 Dec 2005 05:50:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05757-03; Tue, 13 Dec 2005 05:50:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 17B69253A4F; Tue, 13 Dec 2005 05:50:43 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Dec 2005 05:50:41 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 721A4251CAC for ; Tue, 13 Dec 2005 05:50:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05654-10 for ; Tue, 13 Dec 2005 05:50:41 -0500 (EST) Received: from mail01.uk.atosorigin.com (mail01.uk.atosorigin.com [212.248.242.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB0092539B7 for ; Tue, 13 Dec 2005 05:50:40 -0500 (EST) Received: from ukcnm066.uk.int.atosorigin.com ([172.17.190.3]) by mail01.uk.atosorigin.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 13 Dec 2005 10:53:43 +0000 Received: From UKCNX002.uk.int.atosorigin.com ([157.203.248.11]) by ukcnm066.uk.int.atosorigin.com (WebShield SMTP v4.5 MR1a P0803.345); id 1134471035914; Tue, 13 Dec 2005 10:50:35 +0000 Received: from UKDCX001.uk.int.atosorigin.com ([157.203.218.46]) by UKCNX002.uk.int.atosorigin.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 13 Dec 2005 10:50:35 +0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: Remote procedure call via DBMS_PIPE/AQ/whatever Date: Tue, 13 Dec 2005 10:50:35 -0000 Message-ID: <16E1010E4581B049ABC51D4975CEDB8807EF48A5@UKDCX001.uk.int.atosorigin.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Remote procedure call via DBMS_PIPE/AQ/whatever Thread-Index: AcX/0wuljYA+G+1cQhOxuqxw4Djz5w== From: "Moore, Paul" To: "Oracle-L (E-mail)" X-OriginalArrivalTime: 13 Dec 2005 10:50:35.0714 (UTC) FILETIME=[0C294220:01C5FFD3] X-archive-position: 29119 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Paul.Moore@atosorigin.com Precedence: normal Reply-To: Paul.Moore@atosorigin.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org 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