ckerrors.sql

REM *************************************************************************** 
REM 
REM        TITLE:
REM        AUTHOR:
REM        DESCRIPTION:
REM
REM
REM
REM        USAGE W/ PARAMETERS:
REM        
REM        TABLES USED:
REM
REM  MODIFICATION ALLOWED (Y/N):	
REM  MODIFICATION HISTORY:
REM  WHO          WHEN         WHAT
REM  --------------------------------------------------------------------------
REM               MM/DD/YY     INITIAL CREATION
REM
REM ***************************************************************************
rem  derrors.sql
rem
col owner noprint
col name noprint
col type noprint
rem
col line format 999
col position format 999 heading 'POS'
col text format a70 wrap
rem
select owner, name, type, line, position, text
  from sys.dba_errors
 where owner like upper('%&owner%')
   and name like upper('%&name%');