Wish List: Add to PLD help - Login.sql and AfterConnect.sql

[CTzen]

Marco,

is it possible to add to help file list of sql files PL/SQL Developer calls and their proper usage? E.g. loging.sql and afterconnect.sql, what windows (command, sql, test) can and cannot use them, etc.

 

[Marco Kalter]

We'll add this to the documentation.

AfterConnect.sql is called for all sessions created within PL/SQL Developer. Login.sql is called by the Command Window.

 

[jonearles]

Documenting this would be helpful. It took me a while to figure out where the file was located, and how it works. (For example, the file is run every time a new session is created, but doesn't seem to be re-read from disk until the program is restarted.)

Thanks,
Jon

 

[William Robertson]

So where is it? (It's still not documented, and whenever it's mentioned in forum posts they just say the filename.)

I found one by searching the PL/SQL Developer installation directory, however that is readonly by default in Windows 7 so I'm hoping there is a configurable or implicit search path that includes my home directory.

Edit: just found another thread which states that as of 2012 AfterConnect.sql has to be in the installation directory: Running script on login
As that is a read-only directory, I wouldn't say that was much use as a configuration option