ThatJeffSmith

Oracle SQL Developer 101: PLSQL Compiler Warnings, Errors and the Right Gutter

Ever wonder what all the red, yellow, and purple marks in your procedure editor are supposed to tell you in the Oracle SQL Developer Procedure Editor? No idea what I’m talking about?

This:

Ohh, pretty colors!

Ohh, pretty colors!

This is the editor trying to help direct you to where you might have problems, instead of you having to to scroll the text looking for the squiggles.

What squiggles, you ask?

These:

See the yellow-dotted lines?

See the yellow-dotted lines?

Mousing over the line shows you the Compiler Warning. You won’t see compiler warnings unless you turn them on in the preferences.

You can also configure the color and style of the PL/SQL Warning and Error squiggles and lines.

Change the type of line, color, etc.

Change the type of line, color, etc.

But Back to the Right Gutter Space

Red – errors.
Yellow – warnings.
Purple – lines with active editor search results.

Mousing over the little block will give you a preview of the text. Clicking on it will take you to that text.

Hover to preview, click to go to

Hover to preview, click to go to

And just in case you haven’t seen the purple ones before, here’s what a search and it’s set of results look like:

See what 'found' text is before going there

See what ‘found’ text is before going there