Oracle Database Discussions

Hi,
Here I am, with a brand new problem using dg4odbc and MySql.

Sorted out the problem with the field names, now i have something going wrong with my cross-database update procedure.

I created a simple Stored Procedure, with a schema basically as follow:

1) loop on cursor (select from table@mysql)
2) Insert some records into an Oracle table, based on the cursor
3) Update table@mysql (same table from the cursor)
4) End loop

Now, looking on the trace files i see that my procedure hangs on the first update @mysql.

If i run the procedure only with the first insert it works correctly.
If i run the update table@mysql in a separate statement, it works correctly

Any idea? I have the suspect that it could be something related to using a cursor selecting datas from a table trying to update the same table in the loop... am i missing something?