Obtaining Error line number
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Obtaining Error line number

  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Question

    Hi,

    I'm trying to write and error handling set of procedures for a large application. Is it possible to obtain the line number where a pl/sql error occurred? sqlerrm and dbms_utility.format_error_stack do not give me this infomation.

    Oracle workflow manages to do this and log this information into the wf_item_activity_statuses table, does anyone know how it achieves this?


    Thanks.

    Daz.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    U have to use package dbms_debug.

    More indormation u can find in :
    http://docs.oracle.com/cd_a97630/app...ug.htm#1003779

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width