I have a poblema with the addition of rows with decimal values using hs connection between Oracle and db2.

example:
On DB2
CREATE TABLE USER.TEST1 (COD DEC(18,2));

on Oracle
SQL> CREATE TABLE ACOWNER.TEST (COD NUMBER(18,2));

Tabela criada.

SQL> INSERT INTO ACOWNER.TEST VALUES (100.20);

1 linha criada.

SQL> INSERT INTO USER.TEST@DBASET VALUES (100.20);

1 linha criada.

"Here is the problem. Doing manual work. How below does not work."

SQL> SET SERVEROUTPUT ON
SQL> declare
2 CURSOR C1 IS SELECT COD FROM ACOWNER.TEST;
3 begin
4 FOR R1 IN C1 LOOP
5 DBMS_OUTPUT.PUT_LINE(R1.COD);
6 INSERT INTO USER.TEST@DBASET (COD)VALUES (R1.COD);
7 END loop;
8 end;
9 /
100.2
declare
*
ERRO na linha 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from DBASET
ORA-06512: at line 6

thanks

Carlos