Oacle SQL error codes.

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