Just really getting rolling with SQLcl, looooong time SQLPlus user. Over all I think it's great. Many of the scripts I use have a verity of set commands to start them off to get the environment set up correctly. Two of them seem to be acting a bit oddly.
SQL> set autoprint off
SP2-0265: autoprint must be set ON or OFF
SQL>
SQL> show autoprint
autoprint OFF
SQL>
Also it appears if you turn it ON you can't turn it off. (It's default is OFF)
SQL> set autoprint on
SQL>
SQL> show autoprint
autoprint ON
SQL>
SQL> set autoprint OFF
SP2-0265: autoprint must be set ON or OFF
SQL>
SQL> show autoprint
autoprint ON
SQL>
Also the AUTOTRACE now has feedback telling you the setting weather on or off.
SQL>
SQL> set autotrace off
Autotrace Disabled
SQL>
Which I guess is OK, but its just "extra" info that I don't want to see as I run a script. Would be nice to be able to turn off this output.
SQL> @dosql emp emp emp
Autotrace Disabled
Autotrace Disabled
+-+-+-+-+-+-+
Starting Test
+-+-+-+-+-+-+