The following code snippets demonstrate how the SETTINGS_READ_* procedures read the setting values with Oracle.
To retrieve the value of the KeepInterval setting:
- 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