VC下利用ProC开发Oracle接口（国外英文资料）.doc

VC下利用ProC开发Oracle接口（国外英文资料） VC USES Pro * C to develop Oracle interfaces This article introduces the method of developing Oracle database interface programs using Pro * C/C + + in Visual C + + environment. Keyword programming, database interface program, Oracle An overview of the There are two main ways to develop an Oracle library interface in Visual c + +. One way is to use Visual c + + provides a variety of database access technology, such as open database connectivity ODBC connection, the data access object DAO, object and embedded database OLE DB and ADO ActiveX data object, etc. Another approach is to embed SQL statements in Visual C + +, which is what is referred to as Pro * C/C + + (referred to as PROC). The former approach is convenient and portable because of the powerful library support for MFC, and is very portable when you are familiar with the VC programming. However, compared to PROC, the application requires two levels of connection to the database communication interface, programming is relatively complex, and execution is relatively low. PROC supports embedded PL/SQL block directly using Oracle libraries, such as the procedural and non-procedural language, combining to form a more powerful development tools, can be developed that could satisfy the requirement of various complex optimization applications, high execution efficiency. Suitable for people familiar with Oracle technology. But applications developed by PROC cannot be ported to heterogeneous database platforms. This article describes the method and concrete steps for developing an Oracle database interface program in Visual c + + environments, and gives a programming example. The description is an example of Visual c + + 6.0 and Oracle8i, and other versions can be changed according to the actual situation. Special files When PROC develops the Oracle library interface under the VC, a few special files are required. 1, the executable file PROCUI PROC. EXE Using Oracle_HOME as the root direct