Debug efficiently
uAlways start with a piece
of code that works.
uComment out portions of the code until it runs
successfully.
ØWithout commenting, errors in packages or complex
routines can be very difficult
to find.
uThe SQL compiler is not perfect.
ØMay indicate that an error exists in a place that is far
from the actual mistake.
ØMost common types of errors:
§Forgetting a semicolon
§Missing a comma in a SELECT statement
§Missing an END statement
uDo not let your routines get too large in the first
place.
ØLimit routines to no more than a few hundred lines
uFind out what the program is doing at various points.
ØMany IDEs include some sophisticated debugging
functionality
ØSet watches and breakpoints in your code.
