`
liss
  • 浏览: 825148 次
  • 性别: Icon_minigender_1
  • 来自: 广州
社区版块
存档分类
最新评论

java.sql.SQLException: ORA-00933: SQL command not properly ended

阅读更多

java.sql.SQLException: ORA-00933: SQL command not properly ended
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:789)
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)
 at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:829)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1115)
 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1263)
 at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226)

 

ORA-00933 SQL   command   not   properly   ended
  Cause: The   SQL   statement   ends   with   an   inappropriate   clause.   For   example,   an   ORDER   BY   clause   may   have   been   included   in   a   CREATE   VIEW   or   INSERT   statement.   ORDER   BY   may   not   be   used   to   create   an   ordered   view   or   to   insertin   a   certain   order.   Also,   an   improper   SQL   ending   occurs   if   IN   clause   is   used   with   only   one   argument   (IN(X),   for   example).   An   IN   clause   must   have   two   or   more   arguments.    
  Action: Correct   the   syntax   by   removing   the   inappropriate   clauses.   It   may   be   possible   to   duplicate   the   removed   clause   with   another   SQL   statement.   For   example,   to   order   the   rows   of   a   view,   do   so   when   querying   the   view   and   not   when   creating   it.   This   error   can   also   occur   in   SQL*Forms   applications   if   a   continuation   line   is   indented.   Check   for   indented   lines   and   delete   these   spaces.    
   
  Copyright   (C)   1995,   Oracle   Corporation

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics