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?

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

4 Comments

  1. Peter Kundrat Reply

    Cool, unfortunately this does not work for PLSQL errors.
    Shall that be reported as a defect or a feature request?

  2. beth bowden Reply

    Hi, Jeff,

    I like using the database copy under tools in sql developer. Is there anyway to capture the script it creates?

    Thanks!

Write A Comment