Method and Realization of Calling External Procedure by Oracle
Yao Yong-chang · 2008
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.