Using Code to Read Setting Values with Microsoft SQL Server

The following code snippets demonstrate how the SETTINGS_READ_* procedures read the setting values with Microsoft SQL Server.

To retrieve the value of the KeepInterval setting:

Use the following code:
declare @vset varchar(255)

exec settings_read_string @vset OUTPUT,'database.cleanup.Usession','ExpiredSessionTimeout'

print @vset
The following message should appear:
PL/SQL procedure successfully completed.

SQL> print vset