Skip to Main Content
Forums

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!

Error ORA-02063, using DB LINK

518500May 29 2009 — edited May 30 2009
hi,

i've created a DB_LINK from FINANCEIRA.WINXP.LAPTOP Database (_SERVER 01_) to FINANCEIRA.WINXP Database (_SERVER 02_).

The fact is that i have an application connected at the FINANCEIRA.WINXP.LAPTOP side that makes SELECT and INSERT calls to FINANCEIRA.WINXP using the DB_LINK. When an INSERT statement is sent by the application from the FINANCEIRA.WINXP.LAPTOP to the FINANCEIRA.WINXP, i receive an error message: ORA-02063, occurring in the table's Primary Key. When i send the same statement by SQLPLUS from the FINANCEIRA.WINXP.LAPTOP side to the FINANCEIRA.WINXP, it works fine.

somebody can help me ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2009
Added on May 29 2009
#general-database-discussions
11 comments
2,522 views