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