Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02064: distributed operation not supported

326554Jan 28 2004 — edited Jan 29 2004

Hi,
We're trying to run a stored procedure over a DB link and are getting the following error:
ORA-02064: distributed operation not supported ORA-06512: at "FAKEUSER.PKG_QUERY_3_1", line 448 ORA-06512: at "FAKEUSER.PKG_QUERY_3_1", line 69 ORA-06512: at "FAKEUSER.SP_VS_2", line 6 ORA-06512: at line 1

Does anyone know what can cause the "distributed operation not supported" message? I believe the stored proc is doing an insert or update on the remote db, if that's relevant...

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2004

Added on Jan 28 2004

#general-database-discussions

4 comments

1,920 views