Skip to Content
0
Former Member
Jul 01, 2009 at 12:06 PM

Error when using receiver JDBC adapter

27 Views

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