calling 'C' external procedures from Oracle from HPUX

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).

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? Received on Thu Feb 17 2005 - 22:39:32 CST