How to add a semicolon to the end of Java code using the Make Code Statement in Editor (12730)

When using the "Make a non-SQL code statement" button in the SQL Editor Window for a JAVA SQL string, the formatting is incorrect if using the same template for TOAD 8.0 under View | Options | SQL Editor | Make Code | Java | Edit. Instead of inserting a semi-colon (;) to the end of the statement, an additional plus (+) sign is added.

This was the template in v8.0:
"%SqlText% " +
"%SqlTextNext% " +

The last line in v8.5.3.2 ends in "+" instead of ";", which is what it ends with in v8.0.

WORKAROUND:

None

STATUS:

Issue fixed in version 9.0.1. The latest version of Toad for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp


In Toad 9.0., select View | Toad Options | Editor | Code Assist | Make Code | Java | Edit. In the Java Language Template box enter a Return key at the end of the second line and enter a Semicolon on the new line:

"%SqlText% " +
"%SqlTextNext% " +
;