Hi fellow Oracle people,
I' ve set up a DB link to a mysql database. I can run a select over that link showing me the contents of a table.
I' ve set up a streams to synchronize a table. After starting the apply process I' received a
ora-01010: invalid OCI operation error error.
I've searched the internet for solutions to this problem, but was unable to find anything useful. Is anybody running streams replication to mysql?
According to the 10g Streams Concepts and Administration Manual
Overview of Heterogeneous Information Sharing
Streams needs to have an Oracle Transparent Gateway for the
Oracle to Non-Oracle Heterogeneous Data Sharing
For Heterogeneous Apply we support:
All of these have Transparent Gateway available.
But MySQL does not use Transparent Gateway.
It uses HSODBC and 3rd party ODBC Driver.