VX/PF2PC is a utility that converts the Oracle SQL calls in pro*Fortran programs to pro*C procedures stored in SQLPC modules.
VX/ForSQL is a utility that converts the Oracle SQL calls in a pro*Fortran program to pro*C procedures stored in an SQLPC modules. VX/PF2PC also modifies the Fortran code to call the new pro*C procedures, so that in one step, pro*Fortran code is converted to Fortran code calling pro*C procedures.
Since about Oracle 11g, the pro*Fortran pre-processor is no longer available through Oracle. Pro*C is still very much supported by Oracle so sites with pro*Fortran now have a way to move forward with Oracle and have Oracle supported pre-processors.
The pro*C procedures no longer depend on the special Fortran-oriented Oracle procedures SQLFX7, SQLFIN and SQLADR to be present in future Oracle release, it’s all pure pro*C.
VX/PF2PC reads the existing .pfo files and generates a .pc file with the associated .h file and a simplified .F source file along with a .inc file with the procedure heads. At that time, the .pc file is run through the Oracle pro*C pre-processor and the proc-generated .c file is compiled with the Gnu C compile and the resulting .o file is linked with the object file generated by the Fortran compiler using the new .F file.
The .pc file contains all the SQL calls extracted from the .pfo file and creates a procedure for each of these SQL calls in pro*C. It names each procedure so that it is unique in the new .pc files. It also stores the procedure head in C format in the .h files, and it stores the procedure head in Fortran format in the .inc file. At the same time, it creates a .F file that now has the SQL code commented out and in place of the SQL code, it now has the procedures that match the ones in the .pfo code and the .inc file.
Page Is Being Updated