Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Environment variable setting under External Procedure

Environment variable setting under External Procedure

From: <wilson.wong_at_mail.sprint.com>
Date: Tue, 10 Nov 1998 20:19:12 GMT
Message-ID: <72a740$1vs$1@nnrp1.dejanews.com>


I have written a "C" external procedure under Solaris Oracle8. According to Oracle8 manual, the external procedure will be excuted by extproc process which was forked by the Oracle8 Server. I would imagine the extproc should inherit the environment variables from the Oracle Server, I have added the new environment variable into the Oracle userid's profile and I also put the environment variable into the "dbstart" script. None of this seems to work, my external perocedure program failed in "getenv" of the environment variable. Question: how are the environment variables generated in the extproc process? What do I need to do to add one ?
Thanks in advance

Wilson

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 10 1998 - 14:19:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US