Re: pro*c and oracle

"Michael L. Hostbaek" wrote:
>
> Hi,
>
> I have some .pc files I have to edit (I discovered that these are pro*c
> source files) and the guy who originally wrote the code provided zero
> documentation (typical)...
>
> I feek quite comfortable in C - however I have never looked at pro*c
> before. And what's with that syntax ;)
> I find out that pro*c is some oracle thing.. Bow my question is the
> program is currently (semi) working .. and it is running uner Linux
> mandrake .. Now - I need to edit the code, and recompile the program -
> however I do not seem to be able to find the compiler... I am pretty
> positive that it is not installed on my Linux box. Is it a windows thing
> or what ?
>
> Any pointers on how to recompile pro*c source would be greatly
> appriciated..
>
> --
> Regards,
> Michael L. Hostbaek
> -= So long, and thanks for all the fish.. =-
No, it is not a windoze thing.

Pro*C is a precompiler which parses a C program containing SQL statements and Oracle directive and changes these into calls into Oracle libraries.

The proc utility is located in $ORACLE_HOME/bin. This being the case, you will need, at a minimum, the Oracle client installed on your machine.

I would suggest the following:

1. Read the Oracle concepts manual.
2. Read the Pro*C/C++ Precompiler Programmer's Guide.
3. Read the Programmer's Guide to the Oracle Precompilers.

-- 
Ron Reidy
Oracle DBA