Re: Help using Pro*C as CGI

rick_at_onramp.net (Rick Brown) writes:

>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?

Better yet, if you're using a Netscape server, you can put this in the obj.conf:

Init fn=init-cgi ORACLE_HOME=/my/oracle/path

You can add additional variables if you need them. If you are using a different server, try setting (and exporting) the variables you need in the startup shell script (might have to make a startup shell script if there isn't already one).

Kevin Received on Wed Aug 13 1997 - 00:00:00 CDT