Re: Help using Pro*C as CGI

From: Rick Brown <rick_at_onramp.net>
Date: 1997/08/11
Message-ID: <rick.84.0013EA80@onramp.net>#1/1

In article <33ef1bd5.5635946_at_news.cc.sunysb.edu> wjakahi_at_mail.techpark.sunysb.edu writes:
>From: wjakahi_at_mail.techpark.sunysb.edu
>Subject: Help using Pro*C as CGI
>Date: Mon, 11 Aug 1997 14:10:37 GMT

>I'm writing a program to retrieve data from the database using Pro*C.
>Everything works fine under my account, but when I try to run it from
>the webserver account, I am unable to login.

>I'm pretty sure the account needs to know where ORACLE_HOME is. How
>can I set this. I'm told the webserver account has no access to
>profile.

Won't something like:

putenv ("ORACLE_HOME=/my/oracle/path");

in your program, immediately on entry to main, do the trick?

Rick Brown
rick_at_onramp.net Received on Mon Aug 11 1997 - 00:00:00 CDT