Home » SQL & PL/SQL » SQL & PL/SQL » ORA-2064 A commit is issued in a coordinated session from an RPC with OUT parameters
ORA-2064 A commit is issued in a coordinated session from an RPC with OUT parameters [message #46453] Tue, 08 June 2004 20:18 Go to next message
Sachin Pawar
Messages: 3
Registered: June 2004
Junior Member
Hi,
This error is raised when i tried to do a commit in a RPC having one OUT parameter.
When i do a commit at my end it works fine but when i do it inside the remote procedure the error raises and I want to do commit at procedure level only and out parameter is neccessary.

Pls help me with this error.

Thanks,
Sachin

Report message to a moderator

Re: ORA-2064 A commit is issued in a coordinated session from an RPC with OUT parameters [message #46462 is a reply to message #46453] Wed, 09 June 2004 07:33 Go to previous messageGo to next message
sverch
Messages: 582
Registered: December 2000
Senior Member
From Metalink:

Note:1026597.6

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.

Report message to a moderator

Re: ORA-2064 A commit is issued in a coordinated session from an RPC with OUT parameters [message #46475 is a reply to message #46462] Wed, 09 June 2004 22:37 Go to previous message
Sachin Pawar
Messages: 3
Registered: June 2004
Junior Member
How can I use the TWO-PHASE transaction model ?
Will it be really useful in this scenario??

or What work around can you suggest for this?

The scenario is like this,

sales database
-------------------
begin
call_remote();
end;

accounts database
------------------
procedure call_remote() as
begin
insert into XYZ (values);
Commit; -- As per ora-2064 I can not give commit here
end call_remote;

For time being I am comming from sales database. But I want to do it on accounts end.

Thanks,
sachin

Report message to a moderator

Previous Topic: Help in Using DBMS_JOB
Next Topic: Duplicate a User/Schema
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 18 11:49:50 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.