There should be many potential ways. It would mostly depend on the limitations of the target server. I'd probably start with a batch executed REXX procedure that would telnet (or ssh) to the target server, execute commands, and parse the result.
There is a remote execute facility I'd also try. Problem is that a lot of these nifty solutions are also attack vectors and are often blocked by firewalls. -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Patrick Lyon Sent: Thursday, June 04, 2009 10:27 AM To: IBM-MAIN@bama.ua.edu Subject: Kicking off an oracle process Hello List - This question was posed to me and I would assume there would be a way to do it, but I do not know how. I seek the knowledge of the list to answer it if possible. A DBA wants to know if there is a way to request the execution of an oracle stored procedure on another server from the mainframe and have the result return to the mainframe. In these days of NFS and such, I would think it would be possible, but could use a little direction on how to achieve this. Once again, thanks in advance to any that reply. Pat L. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html