dg4odbc to mysql database / select only showing half of the resultset
edited Mar 18, 2013 7:38AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 5 commentsAnswered
Hi everybody,
I've managed to connect a 11g database to a mysql database, both running on the same server (redhat 5).
The query to the mysql database using isql is working as intended.
The database link in my oracle database is active, tnsping to the service is also working, listener is up.
I also can do a select from the mysql database, but the result set is incomplete.
I always get only about half of the values, but sqlplus shows that all records have been fetched.
See the following statements... (The mysql table is called "tblTest" and the database link is named "testdblink")
I've managed to connect a 11g database to a mysql database, both running on the same server (redhat 5).
The query to the mysql database using isql is working as intended.
The database link in my oracle database is active, tnsping to the service is also working, listener is up.
I also can do a select from the mysql database, but the result set is incomplete.
I always get only about half of the values, but sqlplus shows that all records have been fetched.
See the following statements... (The mysql table is called "tblTest" and the database link is named "testdblink")
0