Using Code to Read Setting Values with Oracle

The following code snippets demonstrate how the SETTINGS_READ_* procedures read the setting values with Oracle.

To retrieve the value of the KeepInterval setting:

  1. Use the following code:

SQL> variable vset varchar2(255)

SQL> exec settings_read_string(:vset,'database.cleanup.Usession',
'ExpiredSessionTimeout');

2. The following message should appear:

PL/SQL procedure successfully completed.

SQL> print vset

Related Topics

Reading Setting Values

Using Code to Read Setting Values with Microsoft SQL Server



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, September 30, 2016