User Programmatic Interface

Last updated

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:

UPI-Based Libraries

Several libraries depend on UPI, including:

References

  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.


This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.