Oracle数据库调用外部过程的方法与实现

Method and Realization of Calling External Procedure by Oracle

PL/SQL 时是 Oracle 数据库中一个功能强大的工具,通过它可以实现面向事务的 SQL 处理,针对 oracle 数据库 PL/SQL 工具无法实现那些需要复杂计算和处理功能的情况,本文提出了一种在客户端对数据库访问即可调用数据库服务端程序的方法,这种方法可以减小网络开销和降低对客户端的要求。文中介绍了 Oracle 数据库对外部过程调用的机制,详细描述了外部过程的使用步骤,通过具体例子实现了在 Oracle 数据库内部调用存在于服务器的动态库或程序的过程。

PL/SQL is a powerful tool in oracle database.By this tool we can realize transaction-oriented SQL processing. However,to Oracle database,PL/SQL tool can't react on complex calculation and processing.This paper puts forward a method to call programs on server by a program on client,From this way,the network overhead and requirements for client can be reduced.The mechanism of calling external procedure in oracle is introduced in this paper.This paper describes in detail the steps of external procedure,and gives an example to realize the process of calling in Oracle database the dynamic-link library or program in server.