The following procedure has a multi-line comment within its Create statement:
CREATE OR REPLACE PROCEDURE ALLEMPLOYEE
/*comment line 1
comment line 2*/
(vresult IN DATE)
IS...
Formatting the procedure will result in the following:
CREATE OR REPLACE PROCEDURE GITA.ALLEMPLOYEE/*comment line 1
comment line 2*/
(vresult IN DATE)
IS...
Formatter concatenates the first comment line to the Create statement line and right-justifies the rest of the lines.
The CommentsFormatter option Align at the right margin does not have any effect.
WORKAROUND:
Issue only with procedures with Input/Output parameter line. Remove the parameter line, format the code and re-insert the parameter line.
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
This issue is fixed in the beta 10.5 beta version. You can download the beta version at www.toadsoft.com.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center