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