I am working with a large stored procedure. Currently I have this exception code below to catch any exceptions which occur. What I really need information on, is what line number the exception occurred on. Is there a way to get the line number where the error occurred?
WHEN OTHERS THEN
errMsg := "Error occurred ' || SUBSTR(SQLERRM, 1, 199);