Re: Running Pro*C applications as CGI scripts...

In <3670cf60.0_at_news1.uswest.net> "Ben Parrish" <bparrish_at_remove.rvi.net> writes:

>I'm trying to run some CGI scripts built with the Pro*C Oracle precompiler,
>and I've run into two problems, one minor, one not quite so minor, and I'm
>hoping someone can help me out...
 

>For the record, the platform is Solaris 7/Oracle 8/Apache 1.3.3...
 

>Problem 1: If the programs are compiled with shared libraries, they fail,
>since at the time Apache fires off the script, no "LD_LIBRARY_PATH" is set
>to anything.

Well, then se a LD_LIBRARY_PATH. See the mod_env docs, in particular SetEnv and PassEnv.

>Problem 2: The script works fine from a command line, but when run as a CGI
>script, it fails at the point it tries to connect to the server. The rather
>suspect error message I get is:
 

>"Oracle error. Error while trying to retrieve text for error ORA-12545 in
>"..." on line 30 of wtest.pc. "
 

>Line 30 is the "EXEC SQL CONNECT :user IDENTIFIED BY :password;" line.
>12545 is defined in the documentation as "Connect failed because target host
>or object does not exist"...

You are probably missing other environment variables, like all the oracle ones you need. Received on Fri Dec 11 1998 - 00:00:00 CET