ThatJeffSmith

Clickable Error Messages in Oracle SQL Developer v4

So you’ve got your monster script you’re running in SQL Developer and you run into some errors. Wish it were easier to jump to the line where said errors are being reported?

Well in Oracle SQL Developer v4, your wish is our command.

Just Click on the Highlighted Blue Error Text in the Output Panel

Click and go!

Click and go!

And ‘The Movie’

Run code, click on error message, fix code, try again. Repeat as necessary.

Run code, click on error message, fix code, try again. Repeat as necessary.

Did you notice what happens if you insert or delete lines of text in the worksheet? SQL Developer remembers the relative position of the offending line of code so you can always get back to it. Pretty sweet, eh?