Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Blank input lines messing up sqlcl?

Anthony SoraceNov 15 2017 — edited Nov 15 2017

I have a bunch of .sql files created in SQL Developer, where they work fine. When I try to feed these to sqlcl, either on stdin or using @ /My/File.sql, ones with blank lines in them seem to be causing big problems; then blank line ends interpretation of the command as SQL and instead sqlcl starts reading them as commands. For example:

Error starting at line : 16 File @ /Users/a/lib/myfile.sql

In command -

FROM

Error report -

Unknown Command

Is this... expected? Is there a way around this in the tool itself? I can write myself a little pre-processor script, but to that point: is there some list of other differences I should be aware of when feeding SQL that works properly in SQL Developer into sqlcl?

Comments

Processing

Post Details

Added on Nov 15 2017
1 comment
472 views