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.