Re: embedded sql under c on the web question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/12/19
Message-ID: <349bd019.4256861@inet16>#1/1

On 18 Dec 1997 15:56:01 -0800, djd_at_saul10.u.washington.edu (David Doll) wrote:

>
>Hello, I copied the sample2.pc file from the proc directory in the $HOME/oracle
>directory and compiled it. I ran it from the command line and all was ok. I
>then edited the file with some html tags around the text and compiled it
>and copied the exe into my cgi-bin dir. I then tried accessing the exe from
>within Netscape 4.04 on a NT 4 box. (The server is on a sun workstation) I
>keep getting a mesg stating:
>
>ORACLE error --
>ORA-12545: Unable to open message file (SQL-02113)
>
>in my browser window. I have searched all my online and hardcopy Oracle docs
>and have been unable to find out what these errors mean and/or why I can't
>get any output from this simple program...any help, words of wisdom, would be
>greatly appreciated. Thanks.
>
>David
>
>p.s. could you please e-mail your response to me (djd_at_u.washington.edu) thanks.

the environment the webserver runs the cgi-bin program in is typically a minimal environment. things like:

ORACLE_HOME
ORACLE_SID and so on are probably missing. You need to either

put 'putenv("ORACLE_HOME=/foo")' type statements in your code
have a configuration file your cgi-bin program reads to set the enviroment
wrap your pro*c program in a sh script that sets the environment and then runs the pro*c program
configurat netscape to pass through the important environment variables to your cgi-bin process....

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Dec 19 1997 - 00:00:00 CST