Error when using receiver JDBC adapter

[Former Member]

i am using JDBC adapter as receiver(for oracle 10g) now, however i got ORA-00984 error. So i enable logSQLStatement.

then got the following SQL statement from communication channel monitoring:

INSERT INTO BASEINFO(APPNO, BUSSINAME, APPPERSON) VALUES (3, Steven, Lee)

I realize the statement is incorrect, which should be:

INSERT INTO BASEINFO(APPNO, BUSSINAME, APPPERSON) VALUES ('3', 'Steven', 'Lee')

So how can i correct the SQL statement? is there any setting i miss out in configuration?

Thanks

[Former Member]

Answered