Compiling PL/SQL and using TOAD to write stored procedures

• PL/SQL compiler (version?) is quite stupid:  Missing a semi-colon flags a line several lines below where the actual semi-colon is missing.  Likewise for a missing single quote character
• To escape the single quote character, double it.  Therefore four consecutive single quotes is a string consisting of a single quote
• When the compiler reports a compiler error at a certain line, that line # is relative to the start of the Body of stored procedure (assuming you are editing the Body and not the Spec)
• To compile and "save" your stored procedure to the Oracle server in TOAD, be sure to use the "Execute As Script" button () in the Editor.  Do NOT use the "Execute/compile statement at caret" button.
• In order to see debug output (i.e. from DBMS_OUTPUT.PUT_LINE function):  Where does DBMS_OUTPUT.PUT_LINE() output go (in Toad) ?