Vendor Code: 17412 and 17401
SedsoJul 23 2009 — edited Jul 24 2009SQL-DEV V1.5.4
Java Platform : 1.6.0_07
Windows : XP V2002 SP3
Oracle Version : 10.2.0.4.0 - 64bit Production
MSSQL : 2008
Link: DG4MSQL
Steps to reproduce:
Using a public database link which is established between MSSQL and Oracle.
1. <select * from owner.table_name@link> gives error: Vendor Code: 17401 Protocoll violation
2. <select * from owner."table_name"@link> gives error: Vendor Code: 17412 type length is bigger than maximum
- The length of the table names are not related with the error-messages.
- Both of the sql-sentences work fine with most of the tables in the same database (same link).
It is necessary to disconnect og reconnect to keep on working.
How can I get rid of these error codes?
Thanks,
Sedso