Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
In case there is any error in procedures/functions/packages, then during compilation time cursor is not pointing to error location so identifying error location is difficult.
Are you using the worksheet or the procedure editor?
You get exactly what you're looking for if you use the procedure editor.
Here, I've made a typo, and compiled. Two errors are returned. Clicking each error takes me to the line number and cursor position of the error being reported.