Help me solve this : DSNT408I SQLCODE = -104

[saai]

Hi,

I was trying to insert a value into a table at the remote DB2 using the database link.
insert into tkhr_dummy@holi nk2 values (3);
It gave the error:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE
LEGAL ARE: USER

[rohit]

Hi,

Check the data type of the column you are inserting into. If it is character the use ('3');
and if it is integer the use(3).

I think in your case it is char.

Let me know if this solves your problem.

Rohit.