469,963 Members | 2,196 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

Help me solve this : DSNT408I SQLCODE = -104

1
Hi,

I was trying to insert a value into a table at the remote DB2 using the database link.
insert into tkhr_dummy@holink2 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
Dec 18 '06 #1
1 11234
rohit
6
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.
Jan 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Jean-Marc Blaise | last post: by
1 post views Thread by Raquel | last post: by
3 posts views Thread by ilmagowalter | last post: by
10 posts views Thread by scoonie999 | last post: by
reply views Thread by mithubabu1970 | last post: by
reply views Thread by SOI_0152 | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.