Using Code to Read Setting Values with Oracle or Oracle Autonomous Database

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

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


Last Published Tuesday, December 12, 2023