Re: Help! About compiling Proc

minglei_at_iscs.nus.sg (Ming Lei) writes:  

> I urgently need help. I am beginning to use
> proc. I have compiled and linked the sample programs
> in the directory /oracle/proc/demo. but I can't run
> it. The error message is
> ORA-03114: Unable to open message file (SQL-02113).
> I don't know what is wrong.
> Thanks very much.
 

I get a very similar message when I attempt to run a pro*c compiled program from a session which is not connected to an oracle instance. I'm a programmer, not a DBA, but I get  

  ORA-02700: Unable to open message file (SQL-02113).  

when I try to execute something without first connecting my session to an oracle instance. To remedy this, I execute a shell script (provided by my dba) which connects me to an oracle instance. I work on a unix platform, and all the shell script really does is define ORACLE_PATH, ORACLE_TERM, ORACLE_HOME, and maybe a few other shell variables for my unix session.  

If you're on a unix or similar platform, and you try to echo the value of $ORACLE_HOME, I suspect you'll find that the parameter is not set. Remedy that, and I bet you'll be able to execute you're program.  

• Lance (Well, at least you'll get past _that_ error message...)