Re: Pl/SQL Line numbers

You can use dbms_utility.format_call_stack and/or dbms_utility.format_error_stack in a dbms_output.put_line call. Warning: this will print the line number where the exception was raised (if you are raising your own exceptions of course), it will not print the line number where the error occured. AFAIK that can be done by the built-in exception handler only.

Hth,

Sybrand Bakker, Oracle DBA

Sam Habbab <sam_at_hasc.com> wrote in message news:38DBAD1C.6ED5FCA0_at_hasc.com...
> Hi,
>
> In my function, if an error happened then I want to print a message and
> indicate the line where the problem is.
>
> Is there anyway to know the line number during runtime?
>
> Thanks in advance.
>
> S_at_M.
>
Received on Fri Mar 24 2000 - 12:32:00 CST