User_Programmatic_Interface

User Programmatic Interface

User Programmatic Interface

Add article description

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:

References

  1. [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.


Stub icon

This database software-related article is a stub. You can help Wikipedia by expanding it.
Share this article:

This article uses material from the Wikipedia article User_Programmatic_Interface, and is written by contributors. Text is available under a CC BY-SA 4.0 International License; additional terms may apply. Images, videos and audio are available under their respective licenses.