远程调用PACKAGE时，远端的PACKAGE不能有COMMIT/ROLLBACK

  通过DBLINK远程调用PACKAGE，远端的PACKAGE中有COMMIT/ROLLBACK，那么将导致ORA-2064的错误，需修改应用的逻辑或者把远端的PACKAGE建立在本地。

  详见：

 

Problem Description:
====================
  
You are operating a distributed environment. 
 
You have a remote package created for DML processing.  When the
package is executed at the local site it works, but on the on the remote
master site it fails with ORA-2064.
 
However, when you resubmit the package locally at that remote site the package
works.

Search Words:
=============
remotely procedure procedural call rpc plsql

Solution Description:
=====================
 
 
The DML package included a COMMIT. 
 
A remote procedure call (RPC) cannot contain a commit.
 
At the time that the package is resubmitted at the local site, it
is no longer an RPC and executes.