Resources passed to the Oracle RDBMS
| nls_comp / NLS_COMP | |
|---|---|
| Driver resource | nls_comp |
| Environment variable | NLS_COMP |
| Client/Server resource | Set for server only |
| Type | String |
| Default | Not set (Set by the driver based on mode and Oracle version) |
| Description | The value of this resource must be ‘binary’
for SingleByte and MultiByte installations. For Unicode mode, it must be
'linguistic’.
For more information, see To Connect to Oracle. |
| nls_lang / NLS_LANG | |
|---|---|
| Driver resource | nls_lang |
| Environment variable | NLS_LANG |
| Client/Server resource | Set for server only |
| Type | String |
| Default | Not set (Set in db_resource during installation) |
| Description | The value of this resource must be set to
the same value as the Oracle instance the driver connects to. Check the Oracle
table v$nls_parameters for the appropriate values for your database instance.
The following is an example of how to use this parameter:
nls_lang:american_america.WE8MSWIN1252
When operating in Single Byte or MultiByte mode you cannot set the AL32UTF8 character set. Unicode mode does not have this restriction. For more information, see To Connect to Oracle. |
| nls_sort / NLS_SORT | |
|---|---|
| Driver resource | nls_sort |
| Environment variable | NLS_SORT |
| Client/Server resource | Set for server only |
| Type | String |
| Default | binary |
| Description | If the database instance is created with nls
settings that imply a sorting other than binary, you must specify this
resource. The Oracle RDBMS does not handle nls during the evaluation of the
WHERE clause of queries; therefore, unexpected results will occur if nls_sort
is not set to binary.
If unicode mode is enabled, nls_sort must have a value such
as:
You can sort nls_sort by session; however, because the table indexes can only be created in one sorting order, this makes no sense. Changing the value of nls_sort requires the rebuild of all LN indexes. |
| oracle_home / ORACLE_HOME | |
|---|---|
| Driver resource | oracle_home |
| Environment variable | ORACLE_HOME |
| Client/Server resource | Set for server only |
| Type | String |
| Default | Not set (usually set in the tabledef6.2 file) |
| Description | Sets Oracle's ORACLE_HOME environment variable. For more information, see To Connect to Oracle. |
| oracle_local_template / ORACLE_LOCAL_TEMPLATE | |
|---|---|
| Driver resource | oracle_local_template |
| Environment variable | ORACLE_LOCAL_TEMPLATE |
| Client/Server resource | Set for server only |
| Type | String |
| Default | For more information, refer to To Connect to Oracle. |
| Description | The value of this resource is used as the
connect string to Oracle when the Net8™ BEQ adapter is used.
For more information, see To Connect to Oracle. |
| oracle_service_name / ORACLE_SERVICE_NAME | |
|---|---|
| Driver resource | oracle_service_name |
| Environment variable | ORACLE_SERVICE_NAME |
| Client/Server resource | Set for server only |
| Type | String |
| Default | Not set. |
| Description | The value of this resource is used as the
connect string to Oracle.
For more information, see To Connect to Oracle. |
| oracle_sid / ORACLE_SID | |
|---|---|
| Driver resource | oracle_home |
| Environment variable | ORACLE_HOME |
| Client/Server resource | Set for server only |
| Type | String |
| Default | Not set (Normally set in the tabledef6.2 file) |
| Description | Sets Oracle's ORACLE_SID environment variable. For more information, see To Connect to Oracle. |