Running an initialization script after connecting to the database

07 Feb 2017

KeepTool 12.1.3 introduced the ability to designate an initialization script to run immediately after logging on to Hora. For each database connection, an initialization script can be set in the expanded section of the Connect dialog window:

Although you may already have some ideas in mind for using this feature, we’d like to mention two situations in which it might be useful:

The following sample script performs an initialization of some NLS session variables. After that, a PL/SQL block is used to query the logged-in OS user name and pass it to your business logic:

After login, Hora shows a tooltip notification when running the login script:

Back to the overview