Re: Line numbers in PL/SQL

From: Ezr Vinh <d_a_p_at_my-deja.com>
Date: Fri, 09 Feb 2001 19:54:07 GMT
Message-ID: <961hsq$h6r$1@nnrp1.deja.com>

The package specification and package body are stored seperately in the same data dictionary table, but the lines are numbered independently.

You can query the USER_SOURCE data dictionary to find the specific line, or a block of lines, that you're interested in:

SELECT LINE, TEXT
FROM USER_SOURCE
WHERE NAME='MY_PACKAGE' AND TYPE='PACKAGE BODY' AND LINE=line_no
ORDER BY LINE; In article <961gts$g73$1_at_nnrp1.deja.com>, Sean <dolans_at_my-deja.com> wrote:
> Platform: Oracle 8.1.7 on NT 2000
>
> 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?
>
> Thanks,
> Sean
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 09 2001 - 13:54:07 CST