Hi,

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

SQL> begin
2 for i in 1..5
3 loop
4 insert into "b"@mysql values(to_char(i));
5 end loop;
6 end;
7 /
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,
Sinh