-- ************************************************************
-- *** Feel free to use this SQL-code, but please           ***
-- *** do not remove these copyright lines.                 ***
-- *** (C) Roger Felix - Lund - Sweden                      ***
-- *** [roger_felix@hotmail.com, web_master@work.utfors.se] ***
-- *** URL: http://hem.fyristorg.com/publish/index.html     ***
-- ************************************************************

This script creates an error message showing the position of the errors
in the procedures and functions. It might be practical to append this 
script to the procedure and function creating script to get an immediate
description and information on the location of the errors.

EXAMPLE OF OUTPUT:
~~~~~~~~~~~~~~~~~


MAX(TO_CHAR(X.LINE)||DECODE
----------------------------------------------------------------------------------------------------
188                 the_mrc,'-','1','-',the_jobtype,the_costcode,null,the_priority,'-',
189                  sysdate,the_location,loctype,fake_pers,
190                   the_class,the_repsign,the_shift,the_repdate);
191  --->           not_existing_identifier  := sysdate;

                    ^ Error occured here in PROCEDURE MY_PROCEDURE.
                      Error description: PLS-00201: identifier 'NOT_EXISTING_IDENTIFIER' must be declared

192  --->           not_existing_proc;

                    ^ Error occured here in PROCEDURE MY_PROCEDURE.
                      Error description: PLS-00201: identifier 'NOT_EXISTING_PROC' must be declared

193           EXCEPTION
194               WHEN OTHERS THEN
195  --->            e := sqlerr;

                     ^ Error occured here in PROCEDURE MY_PROCEDURE.
                       Error description: PL/SQL: Statement ignored

196                  insert into debug values ('COULD NOT CREATE NOTIFY WO DUE TO: '||e);

197                  COMMIT;
198           END;

11 rows selected.

real: 1862