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