SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get line number for stored procedure code during exception

5108Nov 13 2002

Dear Sir,

How do i get the line number of my store procedure
when error occurs so that i can capture in the EXCEPTION
and display in our application customise error message alert.

I am referring to a PLSQL web application, running Oracle 9iAS, Oracle8i 8.1.6.

Please advise.
Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2002

Added on Nov 13 2002

1 comment

552 views