Using Code to Read Setting Values for Oracle

Contents

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

To retrieve the value of the KeepInterval setting in Oracle:

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