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
andFLUSH CACHE GROUP
. -
All TimesTen replication management DDL statements, including
CREATE REPLICATION
,DROP REPLICATION
,ALTER REPLICATION
,CREATE ACTIVE STANDBY PAIR
,ALTER ACTIVE STANDBY PAIR
andDROP 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 theCHR()
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
\u
xyzw
syntax (forNCHAR
andNVARCHAR2
only) where you substitute the unicode value forxyzw
, as in\ufe4a
.The
\u
xyzw
notation is not supported by the Oracle database. Thus, any unicode strings inNCHAR
orNVARCHAR2
columns passed through to an Oracle database must be passed as an argument within theUNISTR()
function without theu
character.The following example inserts the unicode values
'0063'
and'0064'
, which are thea
andb
characters respectively. Since we are usingPassThrough
=3, this statement is performed on the Oracle database; thus, we do not provide theu
character as we would if this was performed on TimesTen.Command> INSERT INTO my_tab VALUES (UNISTR(n'\0063\0064')); 1 row inserted.
-