Oacle SQL error codes.

最新推荐文章于 2022-12-25 23:26:32 发布

原创最新推荐文章于 2022-12-25 23:26:32 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #insert #delete #merge #null #object

Oracle 专栏收录该内容

23 篇文章

订阅专栏

本文深入分析了SQL程序中遇到的两个常见错误：对象引用无效导致的Statement is ignored...和语法错误PLS-00103。通过详细解释错误原因并提供解决方案，帮助开发者解决SQL编程中遇到的问题。

1) The table/sequence in the procedure does not exist which cause "Statement is ignored ..."

SQL>@Logging.sql

LINE/COL ERROR

-------- -----------------------------------------------------------------
14/2 PL/SQL: Statement ignored

14/2 PLS-00905: object ECRPUSER.OS_DEBUG is invalid

2) PLS-00103, execute DDL in PS/SQL procedure which is not allowed directly. Should use 'EXECUTE IMMEDIATE'.

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1      PLS-00103: Encountered the symbol "DROP" when expecting one of
         the following:
         ( begin case declare exit for goto if loop mod null pragma
         raise return select update while with <an identifier>
         <a double-quoted delimited-identifier> <a bind variable> <<
         continue close current delete fetch lock insert open rollback
         savepoint set sql execute commit forall merge pipe purge

3) PLS-00103: The code is written with ''BEGIN' but without 'END'.

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   ( begin case declare end exit for goto if loop mod null
   pragma raise return select update when while with
   <an identifier> <a double-quoted delimited-identifier>
   <a bind variable> << continue close current delete fetch lock
   insert open rollback savepoint set sql execute commit forall
   merge pipe purge