Misplaced Pages

User Programmatic Interface

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "User Programmatic Interface" – news · newspapers · books · scholar · JSTOR (January 2014) (Learn how and when to remove this message)
The topic of this article may not meet Misplaced Pages's general notability guideline. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted.
Find sources: "User Programmatic Interface" – news · newspapers · books · scholar · JSTOR (January 2014) (Learn how and when to remove this message)

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) 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:

External links

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.


Stub icon

This database software-related article is a stub. You can help Misplaced Pages by expanding it.

Categories: