D Initialization Parameters

The Oracle database initialization parameters in the init.ora file are distinct from gateway initialization parameters.

Set the gateway parameters in the initialization parameter file using an agent-specific mechanism, or set them in the Oracle data dictionary using the DBMS_HS package. The gateway initialization parameter file must be available when the gateway is started.

The following topics contain a list of the gateway initialization parameters that can be set for each gateway and their description. The topics also describe the initialization parameter file syntax.

• Initialization Parameter File Syntax
  This topic describes the syntax for the initialization parameter file.
• HS_CALL_NAME
  HS_CALL_NAME initialization parameter for Oracle Database Gateway for SQL Server.
• HS_DB_DOMAIN
  HS_DB_DOMAIN initialization parameter for Oracle Database Gateway for SQL Server.
• HS_DB_INTERNAL_NAME
  HS_DB_INTERNAL_NAME initialization parameter for Oracle Database Gateway for SQL Server.
• HS_DB_NAME
  HS_DB_NAME initialization parameter for Oracle Database Gateway for SQL Server.
• HS_DESCRIBE_CACHE_HWM
  HS_DESCRIBE_CACHE_HWM initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_ARRAY_EXEC
  HS_FDS_ARRAY_EXEC initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_AUTHENTICATE_METHOD
  HS_FDS_AUTHENTICATE_METHOD initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_CONNECT_INFO
  HS_FDS_CONNECT_INFO initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_DATE_MAPPING
  HS_FDS_DATE_MAPPING initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_ENCRYPT_SESSION
  HS_FDS_ENCRYPT_SESSION initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_FETCH_ROWS
  HS_FDS_FETCH_ROWS initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_PROC_IS_FUNC
  HS_FDS_PROC_IS_FUNC initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_RECOVERY_ACCOUNT
  HS_FDS_RECOVERY_ACCOUNT initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_RECOVERY_PWD
  HS_FDS_RECOVERY_PWD initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_REMOTE_DB_CHARSET
  HS_FDS_REMOTE_DB_CHARSET initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_REPORT_REAL_AS_DOUBLE
  HS_FDS_REPORT_REAL_AS_DOUBLE initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_RESULTSET_SUPPORT
  HS_FDS_RESULTSET_SUPPORT initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_RSET_RETURN_ROWCOUNT
  HS_FDS_RSET_RETURN_ROWCOUNT initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_SQLLEN_INTERPRETATION
  HS_FDS_SQLLEN_INTERPRETATION initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_SUPPORT_STATISTICS
  HS_FDS_SUPPORT_STATISTICS initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_TIMESTAMP_MAPPING
  HS_FDS_TIMESTAMP_MAPPING initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_TRACE_LEVEL
  HS_FDS_TRACE_LEVEL initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_TRANSACTION_ISOLATION
  HS_FDS_TRANSACTION_ISOLATION initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_TRANSACTION_LOG
  HS_FDS_TRANSACTION_LOG initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_TRUSTSTORE_FILE
  HS_FDS_TRUSTSTORE_FILE initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_TRUSTSTORE_PASSWORD
  HS_FDS_TRUSTSTORE_PASSWORD initialization parameter for Oracle Database Gateway for SQL Server.
• HS_FDS_VALIDATE_SERVER_CERT
  HS_FDS_VALIDATE_SERVER_CERT initialization parameter for Oracle Database Gateway for SQL Server.
• HS_IDLE_TIMEOUT
  HS_IDLE_TIMEOUT initialization parameter for Oracle Database Gateway for SQL Server.
• HS_KEEP_REMOTE_COLUMN_SIZE
  HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter for Oracle Database Gateway for SQL Server.
• HS_LANGUAGE
  HS_LANGUAGE initialization parameter for Oracle Database Gateway for SQL Server.
• HS_LONG_PIECE_TRANSFER_SIZE
  HS_LONG_PIECE_TRANSFER_SIZE initialization parameter for Oracle Database Gateway for SQL Server.
• HS_NLS_LENGTH_SEMANTICS
  HS_NLS_LENGTH_SEMANTICS initialization parameter for Oracle Database Gateway for SQL Server.
• HS_OPEN_CURSORS
  HS_OPEN_CURSORS initialization parameter for Oracle Database Gateway for SQL Server.
• HS_RPC_FETCH_REBLOCKING
  HS_RPC_FETCH_REBLOCKING initialization parameter for Oracle Database Gateway for SQL Server.
• HS_RPC_FETCH_SIZE
  HS_RPC_FETCH_SIZE initialization parameter for Oracle Database Gateway for SQL Server.
• HS_TIME_ZONE
  HS_TIME_ZONE initialization parameter for Oracle Database Gateway for SQL Server.
• HS_TRANSACTION_MODEL
  HS_TRANSACTION_MODEL initialization parameter for Oracle Database Gateway for SQL Server.
• IFILE
  IFILE initialization parameter for Oracle Database Gateway for SQL Server.