Viewing errors in the database : USER_ERRORS « System Tables Views « Oracle PL / SQL






Viewing errors in the database

  

SQL>
SQL>
SQL> -- Viewing errors in the database.
SQL> SELECT LINE, TYPE, NAME, TEXT from user_errors where rownum < 10;

      LINE TYPE         NAME
---------- ------------ ------------------------------
TEXT
--------------------------------------------------------------------------------
         3 FUNCTION     EXITFUNC
PLS-00103: Encountered the symbol "=" when expecting one of the following:

   constant exception <an identifier>
   <a double-quoted delimited-identifier> table LONG_ double ref
   char time timestamp interval date binary national character
   nchar
The symbol "<an identifier>" was substituted for "=" to continue.


SQL>
SQL>
SQL>

           
         
    
  








Related examples in the same category

1.Get detailed error message from user_errors
2.Data dictionary views for valid and invalid