Re: dbms_output package
Date: 1996/01/21
Message-ID: <4dtsla$k7p_at_usenet2.interramp.com>#1/1
Sometimes, the error will be reported on a line that begins an operation such as 'INSERT INTO ...' where the actual error may be on a continuation line such as part of the 'where' clause. Other factors that can cause the error to be reported on another line are improper terminators such as 'end..end if..end loop..or the semicolon'. An improper (or missing) terminator can cause Oracle to keep interpreting until finds something fatal which causes it to stop.
Ken Ingram
Metasys, Inc.
kingram_at_metasys.com
In article <31003DD1.7187_at_fpk.novell.com>, smurty_at_fpk.novell.com says...
>
>Oracle gurus,
> In PL/SQL when I use dbms_output.put_line() to debug stored
>procedures, the line #/col # never seems to match up with the line
>numbers in the text. I tried filtering out all the blank lines in the
>source file with no success. What am I missing here ?
>Any help is greatly appreciated.
>-- Sudarshan
>-------------------------------------------------------------------
>Voice: (201) 443 6092 Sudarshan N. Murty
>Fax: (201) 443 5554 smurty_at_fpk.novell.com
>-------------------------------------------------------------------
Received on Sun Jan 21 1996 - 00:00:00 CET