Toad World® Forums

toad for oracle 12.12 formatting script with multiline ttitle in it.


#1

I have a script that may contain the following 5 lines

TTITLE LEFT ‘POST DATE : &POST_DT_FROM - &POST_DT_TO’ -
CENTER ‘DTDDB - DTD/DTC TRANSACTIONS RESULTING IN DEBIT BALANCE REPORT’ -
RIGHT 'DATE: ’ Today ’ TIME: ’ TIME SKIP 1 -
CENTER ‘NO ACTIVITY IN 9 MONTHS REPORT’ -
RIGHT ‘PAGE #:’ Sql.pno FORMAT 999 SKIP 3

if I click the format option under formatting tools I get the following results

TTITLE LEFT ‘POST DATE : &POST_DT_FROM - &POST_DT_TO’ -
CENTER ‘DTDDB - DTD/DTC TRANSACTIONS RESULTING IN DEBIT BALANCE REPORT’ -
RIGHT 'DATE: ’ Today ’ TIME: ’ TIME SKIP 1 -
CENTER ‘NO ACTIVITY IN 9 MONTHS REPORT’ -
RIGHT ‘PAGE #:’ Sql.pno FORMAT 999 SKIP 3

Everything else formats correctly, it is just this one command. Is there a configuration setting that I need to set or is this a bug in the formatter? Any ideas would be appreciated. The problem is that I might have a 5000 line script with the ttitle command in it and I have to hand modify the ttitle to make it look nice again after I format the entire script.


#2

SqlPlus text should not be “formatted”, this is clearly a bug.

This is fixed in QP5 component version 5.328, which should make it into the beta by the end of next week. (QP-2923)

Thanks for reporting,
Andre