Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

StackOverflowError formatting files using sqlcl

ifernandMar 28 2018 — edited Apr 3 2018

Hi.

I am formatting several sql files using sqlcl, but I have noticed that when I try to format files bigger than 200k bytes sqlcl is aborted

SQL> format file D:\inserts.sql D:\inserts.format.sql

Exception in thread "main" java.lang.StackOverflowError

    at oracle.dbtools.util.Array.indexOf(Array.java:81)

    at oracle.dbtools.util.Array.indexOf(Array.java:81)

    at oracle.dbtools.util.Array.indexOf(Array.java:83)

    at oracle.dbtools.util.Array.indexOf(Array.java:81)

    at oracle.dbtools.util.Array.indexOf(Array.java:81)

    at oracle.dbtools.util.Array.indexOf(Array.java:83)

    at oracle.dbtools.util.Array.indexOf(Array.java:83)

    at oracle.dbtools.util.Array.indexOf(Array.java:83)

    at oracle.dbtools.util.Array.indexOf(Array.java:83)

    at oracle.dbtools.util.Array.indexOf(Array.java:83)

    at oracle.dbtools.util.Array.indexOf(Array.java:83)

    at oracle.dbtools.util.Array.indexOf(Array.java:56)

    at oracle.dbtools.parser.Earley.followComplete(Earley.java:791)

    at oracle.dbtools.parser.Earley.tree(Earley.java:739)

    at oracle.dbtools.parser.Earley.followComplete(Earley.java:810)

    at oracle.dbtools.parser.Earley.tree(Earley.java:739)

    at oracle.dbtools.parser.Earley.followComplete(Earley.java:815)

    at oracle.dbtools.parser.Earley.tree(Earley.java:739)

    at oracle.dbtools.parser.Earley.followComplete(Earley.java:810)

    at oracle.dbtools.parser.Earley.tree(Earley.java:739)

    at oracle.dbtools.parser.Earley.followComplete(Earley.java:815)

    at oracle.dbtools.parser.Earley.tree(Earley.java:739)

.......

It's working fine with files under 200k bytes.

Regards.

Comments

Post Details

Added on Mar 28 2018
3 comments
697 views