Error of Oracle Database Gateways for ODBC for MySQL
I installed and configured Oracle Database Gateways for ODBC for MySQL.
Everything seems ok.
- When I tried inserting row to MySQL ==> OK :
SQL> insert into "b"@mysql values(to_char(1));
1 row created.
- But when I tried inserting by loop ==> error
2 for i in 1..5
4 insert into "b"@mysql values(to_char(i));
5 end loop;
for i in 1..5
ERROR at line 2:
ORA-04052: error occurred when looking up remote object sinh.b@MYSQL
ORA-00604: error occurred at recursive SQL level 1
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[MySQL][ODBC 5.1 Driver][mysqld-5.0.45]SELECT command denied to user
'sinh'@'localhost' for table 'b'
ORA-02063: preceding 2 lines from MYSQL
Anyone know reason and how to fix this error? Please help me.
Thanks in advance,