Re: C Programming

The keyword for discussion is "Pro*C" aka "proc". The second keyword is "Net8".

You can use these to check the archives, isolate the appropriate documentation from http://docs.oracle.com, and google for other sites that answer this problem.

Pro*C is a precompiler to translate embedded SQL commands into the appropriate underlying syntax suitable to connect to Net8. You first ProcC your source to get pure C code with the relevant library calls. The Oracle supplied makefiles then can be used to compile your C code.

If you have done a proper 'client for development' install, you should find a "proc" subdirectory in Oracle_Home and there are examples in that directory. (Or at least, used to be - I'm going on Oracle v7 memories). Best thing to do - if there, use the demo examples to test.

After you have compiiled C code with the libraries, the libraries connect to the database using Net8 (even if you decide to use ODBC instead of ProC). Therefore, you must have Net8 properly installed on the 'final' client - the one that actually needs to connect to the database. (Term final is especially valid if you use some for of multi-tier computing, such as a multiplexor or web-based access.)

I find that 99% of the issues come from the Net8 configuration, or the lack thereof.

HTH
/Hans Received on Mon Jun 16 2003 - 17:27:27 CEST