Using Code to Read Setting Values for Microsoft SQL Server

Contents

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

To retrieve the value of the KeepInterval setting in SQL:

1. Use the following code:

   declare @vset varchar(255)

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

   print @vset

2. The following message should appear:

   PL/SQL procedure successfully completed.

   SQL> print vset