Re: Need help creating PL/SQL stored procedure
From: Bob Treumann <btreuman_at_empros.com>
Date: Mon, 8 Nov 1993 22:16:29 GMT
Message-ID: <CG71vI.Av0_at_empros.com>
Date: Mon, 8 Nov 1993 22:16:29 GMT
Message-ID: <CG71vI.Av0_at_empros.com>
Keyword
You need a simple query to join the error tables, like the following. Cut it to a file called see_err.sql and run it after you compile.
Rem !# Shows the error along with the text and position of the
rem !# bad line.
set arraysize 1
column stext newline
select us.name, us.line, ue.position, us.text stext, ue.text
from user_errors ue, user_source us
where ue.name=us.name
and ue.line=us.line
/
Received on Mon Nov 08 1993 - 23:16:29 CET