pro*C in oracle XE

Question

I downloaded the free express edition of oracle, Oracle XE. I couldn't find the pro*c compiler in this edition. I read somewhere that oracle 9i client has pro*C, So I presumed that oracle client for 10g XE should have it too and downloaded it. But to my disappointment, I can't find it there too. :(. Is there a way to download the older oracle 9i and use it connect to 10g XE without any compatibility problems?. Or is it possible to download the pro*C compiler alone?. I don't want to download the standard editions as they are too large(2 GB).

Thanks.

Answer 1

SHORT ANSWER: For XE, you will need to download and install the 10g client into a new software home.

BACKGROUND: The pro*c precompiler for 10g was actually not released with the database software installation, but only in the separate client installation.

ADDITIONAL INFO: If you were working with anything other than XE, you can use the client installation to "Add" to the existing database install.