开发者

Oracle Query not executing properly in eclipse

I am executing a simple database query in Eclipse:

statement.executeUpdate(
    "INSERT INTO DBUSER(USER_ID,USERNAME,CREATED_BY,CREATED_DATE) 
    VALUES (3,'KUMAR','ERPDIRECT',to_date('29/08/2011', 'dd/mm/yyyy'));"
);

But am getting:

ORA-00911: invalid character error

B开发者_开发技巧ut When am executing this query in sql*plus command line it was executing without fail.


Try removing the trailing semi-colon from the SQL string. It's not necessary when executing via JDBC, and may in fact be an error.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜