| ORA-02064: distributed operation not supported [message #503829] |
Wed, 20 April 2011 00:42  |
hitkan1984
Messages: 4
Registered: October 2007
|
Junior Member |
|
|
Hi All,
When I try to call a database procedure written in Oracle 8.1.7.4.0 with OUT parameter and COMMIT statement from my Oracle 10g environment, I am getting error like "ORA-02064: distributed operation not supported".
I cannot omit OUT/COMMIT statement from the procedure because it is also updating another table from called procedure.
So can anyone help me out for some solution?
I have tried some solutions from my end, but it is not working and same error generating.
Like;
1) Moved the update statement with COMMIT statement to another procedure and calling that procedure from main called procedure
2) Creating a job to run the newly created procedure and submit the job from called procedure
etc.
Thanks....
|
|
|
|
| Re: ORA-02064: distributed operation not supported [message #503832 is a reply to message #503829] |
Wed, 20 April 2011 00:47  |
 |
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Quote:ORA-02064:
distributed operation not supported
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.
Action: simplify remote update statement
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
