User Programmatic Interface

In computing, the User Programmatic Interface (UPI), also known as the User Program Interface, consists of a set of C-language software APIs which provide the lowest-level API-based interface to the Oracle database.

Overview

UPI offers a procedural API for not only performing certain database administration tasks (such as system startup and shutdown), but also for using PL/SQL or SQL to query, access, and manipulate data. The UPI library, an undocumented API used internally by Oracle, deals directly with the Two-Task Common (TTC)[1] aspect of the Oracle Client software stack.

UPI-based applications

Several Oracle database applications depend on UPI, including:

Oracle Forms
SQL*Plus (also uses OCI)
Oracle Corporation's data-import and -export (IMP/EXP) utilities

UPI-Based Libraries

Several libraries depend on UPI, including:

Oracle's FormsAPI
The Oracle Call Interface Library
Oracle's SQLLIB (used by Oracle's Embedded SQL Precompilers)

External links

Oracle SQL*Net Overview (includes basic UPI information)

References

Achacoso, Robwert; et al. (December 2009). Oracle Database Net Services Administrator's Guide 11g Release 2 (11.2). Oracle Corporation. Retrieved 2010-02-14. Two-Task Common (TTC)[:] A presentation layer type [...] used in a typical Oracle Net connection to provide character set and data type conversion between different character sets or formats on the client and server.

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.

[1] Achacoso, Robwert; et al. (December 2009). Oracle Database Net Services Administrator's Guide 11g Release 2 (11.2). Oracle Corporation. Retrieved 2010-02-14. Two-Task Common (TTC)[:] A presentation layer type [...] used in a typical Oracle Net connection to provide character set and data type conversion between different character sets or formats on the client and server.