The last time I was involved in doing this on a PC, you had to use Microsoft Visual C. You obviously also need the Oracle programmer suite and that should be it.
I have to say though, why are you wanting to use Pro*C ? It is frankly horrible and very complex to get working on a PC, creating DLL's and pointing at that DLL, etc, etc, etc and you can do 99% of Pro*C stuff in PL/SQL and the other percent you could do using Java, that is if you are using Oracle 8i.
Hi , friend,
My DB is oracle73 and I don't have plan to upgrade it to
8i . Actually the Prc*c is just calling a store procedure (which
is return in pl/sql) So I need only a minal set of Pro*c env.
I get it, you want a standalone EXE to run the stored procedure. I never actually did this, our's was to create userexits, but I am pretty sure that you only need MS VC and Oracle programmer. It's still a pain in the neck, but less than userexits.
Best of luck getting it working, I am pretty sure the documentation will get you through it.