Supported characteristics of the Connector for Oracle

The following list captures supported characteristics of the Connector for Oracle.

For a definition of the terms used in this section, see "Supported Connector Characteristics -- List of Terms" in Chapter 3 of this manual. If you are accessing the Connector using LotusScript®, see the Connector LotusScript® Extensions Guide for more information.

Writeback support -- Full writeback support. The connection supports updatable cursors (update and remove)
Writeback index -- Index strongly advised, but not required. Use the command "create index <indexname> on <tablename> (<column1>, <column2>, ..., <columnN>)"
Statement syntax -- Full PL/SQL syntax. To execute stored procedures, use the following syntax: "BEGIN <stored procedure> (<parm1>, <parm2>, ..., <parmN>) ; END ;"
Condition syntax -- Valid when placed in the following Oracle statement: SELECT ... WHERE <condition> ORDER BY ...
Actions supported -- Clear, Reset, Truncate, Commit, Rollback
Catalog types -- Metadata, Index, Field, Procedure, Parameter
Create types -- Metadata, Index
Drop types -- Metadata, Index

All connections have a set of properties with values that can be assigned and retrieved. See the Connector LotusScript® Extensions Guide for a list of supported properties for each Connector. Also see the "Common Connector Properties" and "LCConnection Properties" sections in the LCConnection Class of that same manual.