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:
declare @vset varchar(255)
exec settings_read_string @vset OUTPUT,'database.cleanup.Usession','ExpiredSessionTimeout'
print @vset
PL/SQL procedure successfully completed.
SQL> print vset
Using Code to Read Setting Values with Oracle
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, September 30, 2016