SQLPLUS, login.sql and 12.2 in the cloud or not

Another little hiccup in 12.2 this time with SQLPlus.  It appears that it will not run the login.sql in your current directory as it always has in the past.    

There seems to be a problem with SQLPlus and SQLCL using the SQLPATH setting.  SQLPlus as far as I can tell, still uses SQLPATH as it always has for running a SQL file like:

SQL> @emp

    EMPLOYEE_ID FIRST_NAME           LAST_NAME                 EMAIL

--------------- -------------------- ------------------------- -------------------------

            105 David                Austin                    DAUSTIN

            151 David                Bernstein                 DBERNSTE

            165 David                Lee                       DLEE

SQL>

In SQLPlus, the GET command as far as I know has never used SQLPATH to find files, it only looks in the current directory, and that seems to be working like normal.  

But SQLCL the GET command doesn’t appear to be working correctly.  You can get it to look in what SQLPATH is set to as long as SQLPATH only has ONE directory in it.  If SQLPATH has multiple entries (which mine does) then it doesn’t use it at all. 

This is a known issue in SQLPlus and you can look it up under this document number in your myoraclesupport account.  Doc ID 2274608.1   By the way, the doc talks about the glogin.sql file not being run, that doesn’t appear to be the case for me.  My fix was to add a call to my login.sql file in the glogin.sql file (in ORACLE_HOME/sqlplus/admin) and it worked just fine. The doc indicates that if the glogin.sql file is in some other directory pointed to by SQLPATH it doesn’t work, that very well may be true.  

I’ve logged an SR about the issue with SQLCL. I presume there is some common code between the two hence they seem to be related.