Mega Code Archive
Viewing Errors in a Database
<![CDATA[
SQL>
SQL> SELECT LINE, TYPE, NAME, TEXT from user_errors;
INE TYPE NAME TEXT
1 PROCEDURE P PLW-06002: Unreachable code
10 FUNCTION DELETEEMPLOYEE PL/SQL: ORA-00904: "EMPLOYEE": invalid identifier
7 PROCEDURE DELETEMYEMPLOYEE PL/SQL: ORA-00905: missing keyword
7 FUNCTION DELETEEMPLOYEE PL/SQL: SQL Statement ignored
4 PROCEDURE DELETEMYEMPLOYEE PL/SQL: SQL Statement ignored
3 PROCEDURE HELLOFLE PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following:
LINE TYPE NAME TEXT
--------------------------------------------------------------------------
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor external language
The symbol "begin" was substituted for "DECLARE" to continue.
18 PROCEDURE HELLOFLE
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
24 PROCEDURE COMPILE_WARNING
LINE TYPE NAME
---------- ------------ ------------------------------
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLW-06002: Unreachable code
1 PACKAGE PKG
PLS-00103: Encountered the symbol "TEST1" when expecting one of the following:
is authid as compress compiled wrapped
The symbol "authid" was substituted for "TEST1" to continue.
9 rows selected.
]]>