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% " +
;
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy