formatting large files with repetitive statements, i.e. insert about plsql-formatter-settings HOT 3 CLOSED

Hi @plamen-ppv

Right, there are some SQL constructs which are slow to process and may fail when running from SQLcl. There are two workarounds:

a) use the standalone formatter tvdformat.jar. It's still slow, but it usually finishes (not feasible for interactive usage)
b) exclude the files from processing via the an ignore configuration . I use this approach in various projects where I format the code via pre-commit hook. You could also create a batch-file so you do not have to pass the ignore parameter each time.

I do not see an easy way to identify problematic files. It is not always the size. Also, very large lists (in or type constructors) are problematic, even if the file is small. So using the ignore parameter seems to be the best approach IMO.

from plsql-formatter-settings.

If the root cause of the slow Arbori queries cannot be addressed an option could be to define a timeout option with a default value of let's say 10 seconds per file. If the timeout is reached the formatting process for the current file could be aborted.

from plsql-formatter-settings.

Adding such timeout option will be the most pragmatic solution! it will cover all cases, regardless of origin.

from plsql-formatter-settings.