Skip to Main Content

SQL & PL/SQL

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!

Does SQL*Plus still automatically execute login.sql on Windows 10 when you launch SQL*Plus?

RedWhiteNBlueMar 12 2020 — edited Mar 15 2020

I'm trying to get SQL*Plus to automatically execute my login.sql script that I've created. I've verified that the SQLPATH registry entry is in my Windows 10 registry. I've put the login.sql file in every possible folder that might be a target of where SQL*Plus is looking for it.

My ORACLE_HOME is dbHomeXE and SQLPATH is the child of ORACLE_HOME called 'dbs'. I still can't figure out if this is not set up right or it just has to be done manually these days, which would be sad if true. I say that because I've spent a lot of time trying to figure this out myself and read a lot of different articles that talked about how this functionality has changed between versions due to security. But it seems like the answer to this question is like finding a needle in a haystack.

Comments
Post Details
Added on Mar 12 2020
17 comments
2,478 views