Overview of PL/SQL

Applications can use PL/SQL to access and manipulate data. PL/SQL is processed on the element to which the application is connected. See Oracle TimesTen In-Memory Database PL/SQL Developer's Guide for detailed information on PL/SQL and examples.

Consider the following when using PL/SQL in TimesTen Scaleout:

• SQL statements that are invoked from PL/SQL are run across the grid as with any other SQL statement.

• PL/SQL functions or procedures are run as local operations.

• As with other SQL objects, TimesTen Scaleout automatically creates all PL/SQL objects when new elements are added to the distribution map of the database.

• As with other DDL statements, TimesTen Scaleout logs PL/SQL DDL statements. PL/SQL objects created or dropped while an element is down are created during the recovery phase of the element. However, PL/SQL DDL statements are blocked on the database during the log-based catch up recovery phase of the element, just like any other DDL operation.

TimesTen Scaleout supports most, but not all, PL/SQL features supported by TimesTen Classic. For unsupported PL/SQL features, see Table 1-9.