sakthikumar
asked on
ORA-02064 distributed operation not supported. How to resolve.?
I have a remote procedure with out parameter, that has commit inside,
when i tried calling the remote procedure, I am getting 02064 error.
Is there any other solution. how can I call this?
when i tried calling the remote procedure, I am getting 02064 error.
Is there any other solution. how can I call this?
try to use automonous transaction pragma at your local procedure, wich calls that remote one
ASKER
May I know the reason, how autonomous transaction help solve this problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great, Can I know the reason how this is possible with autonomous transactions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cause: One of the following unsupported operations was attempted:
1. array execute of a remote update with a subquery that references a dblink, or
2. an update of a long column with bind variable and an update of a second column with a subquery that both references a dblink and a bind variable, or
3. a commit is issued in a coordinated session from an RPC procedure call with OUT parameters or function call.
simplify remote update statement, so that it will be resolved