Oracle Connector Properties
The following table defines the properties for the Connector for Oracle.
| Token |
Name/Description |
Type |
|---|---|---|
| LCTOKEN_SERVER |
Server Oracle Host Name. Required. |
Text |
| LCTOKEN_USERID |
Userid User ID/name -- used for logging in during connection |
Text |
| LCTOKEN_PASSWORD |
Password Password -- used for logging in during connection |
Text |
| LCTOKEN_METADATA |
Metadata Data table or view: the source or target for data transfer operations. |
Text |
| LCTOKEN_INDEX |
Index Index name. |
Text |
| LCTOKEN_MAP_NAME |
MapByName Whether to map by name or position when transferring data between data source and target. |
Boolean |
| LCTOKEN_WRITEBACK |
Writeback Whether to perform writeback or non-writeback operations. |
Boolean |
| LCTOKEN_FIELDNAMES |
FieldNames Text list of fields to select -- used for Select operations |
Text List |
| LCTOKEN_ORDERNAMES |
OrderNames Text list of fields to order results by -- used for Select operations |
Text List |
| LCTOKEN_CONDITION |
Condition Connector-specific syntax conditional clause -- used for Select operations |
Text |
| LCTOKEN_STAMPFIELD |
StampField Field name of timestamp field -- used for Select operations |
Text |
| LCTOKEN_BASESTAMP |
BaseStamp Minimum timestamp value to include in results -- used for Select operations |
Datetime |
| LCTOKEN_MAXSTAMP |
MaxStamp During a Select operations, set by the connector to the current timestamp value -- set by Select operations |
Datetime |
| LCTOKEN_PROCEDURE |
Procedure Use when executing parameterized stored procedures in a link-independent fashion. When a session is run and this property is set, the property's value is taken as a stored procedure name and is executed instead of the normal selection operation, potentially producing a result set. If a fieldlist is provided to the Select operation, then all fields in that fieldlist (not just key fields) are supplied to the stored procedure as parameters, with the names taken from the field names. |
Text |
| LCTOKEN_ OWNER |
Owner Only objects owned by the owner name in this property are included in the result set |
Text |
| LCTOKEN_ALT_METADATA |
Affects the behavior of METADATA and FIELD catalog types, returning a list of objects of the alternate metadata type instead of the normal metadata type. |
Boolean |
| LCTOKEN_CALL_CONTEXT |
Indicate what the expected behavior of the procedure call. The default behavior is to execute a procedure and expect (but not require) a result. The following context values may provide more specific information: LCCALL_SELECT: check for (but do not require) a result set. LCCALL_INSERT: Do not check for or produce a result set. LCCALL_UPDATE: Do not check for or produce a result set. LCCALL_REMOVE: Do not check for or produce a result set. LCCALL_COMMAND: Do not check for or produce a result set. LCCALL_NONE: No context information - behavior is defined by the connector. |
Integer |
| 1.00 |
CommitFrequency Number of data modification actions between commits. A value of zero causes a commit at disconnect; a value of one auto- commits after every action; any other value commits after that many data modification actions. Note: A commit during
a cursored (writeback) operation following an update unlocks result
set. Therefore, when a writeback result set is active, the commit
frequency property is ignored and commits do not occur. |
Integer |
| 2.00 |
RollbackOnError Whether to rollback the current transaction at disconnection if the session is in an error state. Note: Tokens 3 and 4 are not valid. |
Boolean |
| 5.00 |
TraceSQL Use this option to include all SQL statements generated during the execution of the activity in the activity's log. This can be helpful when you need to troubleshoot the activity. |
Boolean |
| 6.00 |
EnhanceErrorInformation Use this option to include additional error information or warnings in the activities log. |
Boolean |
| 7.00 |
DefaultTranslationFormat Fall back text format. It is the name of the Oracle text format to use if automatic translation fails. |
Text |