Blank input lines messing up sqlcl?

Anthony Sorace

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?

Gaz in Oz

Use sqlcl directive

set sqlblanklines on

in your scripts.

(Default is OFF, same as sqlplus).

From the SQL Dev/sqlcl download page

Oracle SQL Developer Downloads

Command Line - SQLcl 17.3

September 29, 2017 - Update 17.3.0.271.1943All PlatformsLearn More, Command-Line Reference, Release Notes,FAQ, Getting Started Video

                                            ^