How to find Package/Procedure name and Line Number where the program got errored out???

Oracle Apps Interview QuestionsCategory: PL/SQLHow to find Package/Procedure name and Line Number where the program got errored out???
Questions Master asked 10 years ago

Usually it becomes tough to find where the execution sequence of a package got failed. How do we make this easy? so that debugging becomes easy/