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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ora-00910 when connect to SQL Server using transparent gateway.

user3868314Oct 23 2008 — edited Oct 26 2008
Hello,

The version of my Oracle is Oracle 10.2.0.3.

I have a database link between Oracle and SQL Server. And when I try to access a view in SQL Server, I get the following error.
ERROR at line 1:
ORA-00910: specified length too long for its datatype
ORA-02063: preceding line from ****

However, the database link works fine for another views in the same SQL Server database. Could you give me some suggestion or clew on this problem? Thanks for your great help.

Best regards,
Peter

Edited by: user3868314 on Oct 23, 2008 8:21 PM

Edited by: user3868314 on Oct 23, 2008 8:22 PM

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 23 2008
Added on Oct 23 2008
#heterogeneous-connectivity
3 comments
2,744 views