RE: calling external program

From: <Graeme.Farmer_at_mincom.com>
Date: Tue, 6 Jun 2006 07:39:58 +1000
Message-ID: <OFC133C9C0.89C71EEB-ON4A257184.00770240-4A257184.0077036C@mincom.com>

You can use either Java or C via an external procedure call.

I have never used Java but for C you need to create an Oracle LIBRARY object referencing a compiled C (shared) library and a wrapper function/procedure to use your subroutine(s) – (I think the process is similar for Java but welcome correction). LISTENER must also be configured for external procedure calls.

All this info should be in the app developer’s guide in the Oracle doco.

Other than that, I can’t think of a (simple) method of calling an external procedure. (Not simple would mean using UTL_TCP to talk to an external daemon process).

Cheers

Graeme Farmer

graeme.farmer@mincom.com

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of "Edward Lewis" <eglewis@fastmail.fm>
Sent: Tuesday, 6 June 2006 7:27 AM
To: "oracle-l
Subject: calling external program

Hello,
I need to run an external script (unix), from
a stored procedure. I know this can be done with
a Java stored procedure. Any other suggestions ?
thanks.
ed
--
Edward Lewis
eglewis@fastmail.fm

--
http://www.fastmail.fm - IMAP accessible web-mail

--
http://www.freelists.org/webpage/oracle-l

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

-- http://www.freelists.org/webpage/oracle-l Received on Mon Jun 05 2006 - 16:39:58 CDT