Language Elements and Features Not Supported by TimesTen

These language elements are features are not supported in TimesTen.

• Features: autonomous transactions, database links (dblinks), result cache, savepoints, triggers, user-defined objects or collections

  While TimesTen does not support triggers, you can achieve similar functionality using XLA. See XLA and TimesTen Event Management in Oracle TimesTen In-Memory Database C Developer's Guide.

• Statements: CREATE LIBRARY, CREATE TYPE, LOCK TABLE, SAVEPOINT, SET TRANSACTION

• Pragmas: AUTONOMOUS_TRANSACTIONS, RESTRICT_REFERENCES, SERIALLY_REUSABLE

• SYSTIMESTAMP: TimesTen cannot support this because the return type, TIMESTAMP WITH TIME ZONE, is not supported. As an alternative, you can use SELECT tt_sysdate FROM dual using dynamic SQL:

  declare
    ts timestamp;
  begin
    execute immediate 
      'select tt_sysdate from dual'
       into ts;
  -- ts has millisecond resolution
  end;