TimesTen-Only SQL and Built-In Procedures

There are TimesTen SQL statements and functions and built-in procedures that are not supported by the Oracle Database.

With PassThrough=3, these statements are passed to Oracle Database for processing and an error is generated.

• All TimesTen cache group DDL and DML statements, including CREATE CACHE GROUP, DROP CACHE GROUP, ALTER CACHE GROUP, LOAD CACHE GROUP, UNLOAD CACHE GROUP, REFRESH CACHE GROUP and FLUSH CACHE GROUP.

• All TimesTen replication management DDL statements, including CREATE REPLICATION, DROP REPLICATION, ALTER REPLICATION, CREATE ACTIVE STANDBY PAIR, ALTER ACTIVE STANDBY PAIR and DROP ACTIVE STANDBY PAIR.

• FIRST n clause.

• ROWS m TO n clause.

• All TimesTen built-in procedures. See Built-In Procedures in Oracle TimesTen In-Memory Database Reference.

• TimesTen specific syntax for character and unicode strings are not always converted to the Oracle Database syntax when using PassThrough=3.

  Note:

  For more details on TimesTen support for unicode strings, see Character and Unicode Strings in the Oracle TimesTen In-Memory Database Reference.

  • Supplying \046 converts to the & symbol on TimesTen, but is not converted to this symbol when passed through to an Oracle database. The \xyz notation is not supported by the Oracle database. To send a character through to an Oracle database, pass it as an argument within the CHR() function with the decimal value of the character.

  • TimesTen enables depicting a unicode value (a four-digit hexadecimal number) within a character string with the \uxyzw syntax (for NCHAR and NVARCHAR2 only) where you substitute the unicode value for xyzw, as in\ufe4a.

    The \uxyzw notation is not supported by the Oracle database. Thus, any unicode strings in NCHAR or NVARCHAR2 columns passed through to an Oracle database must be passed as an argument within the UNISTR() function without the u character.

    The following example inserts the unicode values '0063' and '0064', which are the a and b characters respectively. Since we are using PassThrough=3, this statement is performed on the Oracle database; thus, we do not provide the u character as we would if this was performed on TimesTen.

    Command> INSERT INTO my_tab VALUES (UNISTR(n'\0063\0064'));
    1 row inserted.