1. PL/SQL Developer's Guide
  2. Introduction to PL/SQL in TimesTen
  3. Overview of PL/SQL Features

Overview of PL/SQL Features

This overview introduces PL/SQL features.

About PL/SQL

TimesTen supports PL/SQL (Procedural Language Extension to SQL), a programming language that enables you to integrate procedural constructs with SQL in your database.

TimesTen Release 22.1 implements the PL/SQL language from Oracle Database release 19c. As such, most PL/SQL features present in that release of Oracle Database are also present in TimesTen, operating in essentially the same way. (Refer to TimesTen PL/SQL Support: Reference Summary for differences.)

Features of PL/SQL in TimesTen

PL/SQL support in TimesTen enables you to do several things.

  • Take full advantage of the PL/SQL programming language.

  • Execute PL/SQL from your client applications that use these APIs:

    • ODBC

    • JDBC

    • Oracle Call Interface (OCI)

    • Oracle Pro*C/C++

    • Oracle Data Provider for .NET (ODP.NET)

    • TTClasses (TimesTen C++ library)

  • Execute TimesTen SQL from PL/SQL.

  • Create, alter, or drop standalone procedures, functions, packages and package bodies.

  • Use PL/SQL packages to extend your database functionality and to provide PL/SQL access to SQL features.

  • Handle exceptions and errors in your PL/SQL applications.

  • Set connection attributes in your database to customize your PL/SQL environment.

  • Alter session parameters so you can manage your PL/SQL environment.

  • Display PL/SQL metadata in your database by using PL/SQL system views.

Note:

See Privileges for PL/SQL Statements and Operations in Oracle TimesTen In-Memory Database Security Guide.