Toad does not format as expected based off of setting specified in the Formatter Options.
Example:
Data typEs and other reserved words should be capitalized. Spacing should have 5 character spaces between variable name and type
PROCEDURE TEST IS
my_var1 NUMBER; (5 space between data type and capital)
my_var2 PLS_INTEGER;
my_var3 VARCHAR2(30);
BEGIN
DBMS_OUTPUT.PUT_LINE('Variable 1'||my_var1);
END;
Conflict with FmtPlus.opt file.
RESOLUTION 1:
Verify that options are being manually saved after changes are made in the View | Format Options window.
Check setting under View | Formatter Options. In the Formatter window, adjust Keyword case setting under Formatter Options | Case | Keywords, spacing under Formatter Options | General | Tabs and under | Statements & Clauses | Variable Declarations.
RESOLUTION 2:
Rename and reset the fmtoptions.ini.
Exit out of Toad, for Toad 9.7, go to C:\Documents and Settings\<personal folder>\Application Data\Quest Software\QP5 and rename the fmtoptions.ini file. Restart Toad and test your issue and reset View | Formatter Options again if necessary.
In Toad versions 9.6 and older, the fmtoptions.ini can be found in the User Files folder of your installation directory.
RESOLUTION 3:
Rename and reset the fmtplus.opt.
Exit out of Toad, for Toad 9.7, go to C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle\9.7\User Files and rename the fmtplus.opt file. Restart Toad and test your issue and reset View | Formatter Options again if necessary.
In Toad versions 9.6 and older, the fmtplus.opt can be found in the User Files folder of your installation directory.
