NLS_NUMERIC_CHARACTERS Parameter
When using HPD SQL scripts, HPD requires that the Oracle NLS_NUMERIC_CHARACTERS parameter be set to ".,", where the decimal symbol is period (.) and the integer grouping symbol is comma (,).
To find out if the Oracle settings are correct, at the SQL Command Prompt, run the following query:
select * from nls_session_parameters; |
Search for the NLS_NUMERIC_CHARACTERS entry in the output.
How to set/change a parameter value:
At the SQL session prompt, type the following:
alter system set NLS_NUMERIC_CHARACTERS='.,' scope = SPFILE; |
The database must be re-started to apply the changes.
Timing Options
An optional parameter can be added to the Oracle Server’s sqlnet.ora file to monitor session activity. If an HPD client session has been inactive for N minutes, the Oracle session is closed.
1. In the sqlnet.ora file, enter the following parameter:
sqlnet.expire_time=5 |
In the above example, Oracle sends a ping every five minutes to see if the HPD client session is still active. If the HPD applications are still open, the Oracle session is not terminated even if the applications are idle.