Re: Line numbers in PL/SQL

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 09 Feb 2001 21:45:45 -0800
Message-ID: <3A84D589.16D04D24@exesolutions.com>

> When you get an ORA error from a PL/SQL package and it says it occurred
> on "line 375", from where in the package does it start? Does it
> include the package declaration as part of the line count or does it
> start within the body and count down from there?
>
> Is there a "quick" way to see the line at which the procedure is dying?

Are you talking about during package creation or package execution?

If package creation ... type SHOW ERROR.

Daniel A. Morgan Received on Fri Feb 09 2001 - 23:45:45 CST