What is Pro*C? Pro*C is the Oracle pre-compiler for the C programming language. It allows you to write embedded SQL statements in your C program -- which is supposed to make it easier to write database programs. The way your program is written is shown below.

First follow the steps shown here for SQL Plus -- i.e., check your UNIX shell on acmex, and run the script oraenv as shown above.

Then, if your program is called 'sample.pc', you can compile it on acmex by running:

     make -f proc.mk EXE=sample OBJS="sample.o"

You can also compile multiple .c files into an executable by specifying them in the OBJS section.

    make -f proc.mk EXE=sample OBJS="sample1.o sample2.o sample3.o"

Here are links to the makefile proc.mk and to a sample Pro*C program .  Before running the Pro*C program, you must run this SQL script first from inside SQLPlus that creates the tables needed.

When saving these files on your account, be sure to save the page itself, don't just copy and paste it into a new file.  If you copy and paste, you will have some end-of-file errors and you won't be able to compile the programs.

Here are some slides on using Pro*C (in postscript):    proc.ps