User Programmatic Interface: Difference between revisions
Moved page from wikipedia:en:User Programmatic Interface ([[Edithistory:|history]]) |
m automatic correction by IA |
||
| Line 11: | Line 11: | ||
==Overview== | ==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. | 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)<ref> | ||
{{cite book | {{cite book | ||
|last= Achacoso | |last= Achacoso | ||
|first= | |first= Robert | ||
|title= Oracle Database Net Services Administrator's Guide 11g Release 2 (11.2) | |title= Oracle Database Net Services Administrator's Guide 11g Release 2 (11.2) | ||
|url= http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/glossary.htm#BGBFHHJG | |url= http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/glossary.htm#BGBFHHJG | ||
Latest revision as of 02:03, 21 April 2026
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
References
- ↑
Achacoso, Robert; 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.
Search this book on
 | This database software-related article is a stub. You can help EverybodyWiki by expanding it. |
This article "User Programmatic Interface" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:User Programmatic Interface. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
