Re: calling 'C' external procedures from Oracle from HPUX

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 18 Feb 2005 01:34:35 -0800
Message-ID: <1108719275.458528.100160@z14g2000cwz.googlegroups.com>

Chris Clark wrote:
> Within PL/SQL we want to be able to access external data within shell
> variables for use within database triggers.
>
> Is the use of an external function/procedure written in 'C' and
called
> via PL/SQL the best/only way to go? (use of GETENV).

Best/Only... Best can be debated but certainly not the only way. If your Oracle version is 8i and above and have installed JServer in the database, then you can also use Java to do this.

>
> If so, could someone show us the compile and link scripts required
and
> also the details configuring Oracle (listener?, publishing).
> Note: we have written 'C' procedures required but are having
> difficulty tying it all together.
>
> Can HPUX, as distinct from LINUX or SOLARIS, even achieve this?

Regards
/Rauf Received on Fri Feb 18 2005 - 03:34:35 CST