Approach to recompile Pro*C programs when upgrading Oracle RDBMS
I am a DBA and not a Pro*C developer so please bear with me on this question.
In the past whenever we upgraded our Oracle RDBMS we would recompile all of our Pro*C programs to the new release of Oracle. Now we are upgrading more frequently with tick releases and since Oracle now supplies a complete install for a tick release it requires a new Oracle Home. This means we have to recompile all of our Pro*c programs must more often.
Our problem is that we have multiple environments (Dev, Qa, UAT and Production) and we do not have the C compiler in our QA, UAT or Production environments. We compile in our Dev environment and migrate the source and executable to the next environment whenever a migration is required.