User Programmatic Interface
- 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 is an undocumented API used internally by Oracle which deals directly with the Two-Task Common (TTC) aspect of the Oracle Client software stack.
UPI-Based Applications
Several libraries are based on top of UPI, including:
* Oracle Forms
* SQL*Plus (also uses OCI)
* Oracle's IMP/EXP Utilities
UPI-Based Libraries
Several libraries are based on top of UPI, including:
* Oracle's FormsAPI
* The Oracle Call Interface Library
* Oracle's SQLLIB (used by Oracle's Embedded SQL Precompilers)
External links
* [http://download-uk.oracle.com/docs/cd/A57673_01/DOC/net/doc/NWUS233/ch2.htm Oracle SQL*Net Overview (includes basic UPI information)]
Wikimedia Foundation.
2010.
Look at other dictionaries:
Interface (computer science) — Interface generally refers to an abstraction that an entity provides of itself to the outside. This separates the methods of external communication from internal operation, and allows it to be internally modified without affecting the way outside … Wikipedia
Oracle Call Interface — In computing, the Oracle Call Interface (OCI) consists of a set of C language software APIs which provide an interface to the Oracle database. OCI offers a procedural API for not only performing certain database administration tasks (such as… … Wikipedia
POSIX terminal interface — The POSIX terminal interface is the generalized abstraction, comprising both an Application Programming Interface for programs, and a set of behavioural expectations for users of a terminal, as defined by the POSIX standard and the Single Unix… … Wikipedia
Authentication Open Service Interface Definition — The Authentication Open Service Interface Definition (OSID) is an O.K.I. specification which supports invoking an authentication process. OSIDs are programmatic interfaces which comprise a Service Oriented Architecture for designing and building… … Wikipedia
Authorization Open Service Interface Definition — The Authorization Open Service Interface Definition (OSID) is an O.K.I. specification which provides the means to define who is authorized to do what, when. OSIDs are programmatic interfaces which comprise a Service Oriented Architecture for… … Wikipedia
Workflow Open Service Interface Definition — The Workflow Open Service Interface Definition (OSID) is an O.K.I. specification which provides the means to define a Process composed of Steps . OSIDs are programmatic interfaces which comprise a Service Oriented Architecture for designing and… … Wikipedia
UPI (disambiguation) — UPI can stand for:*United Press International, a global news agency headquartered in the U.S. *Unique Personal Identificator *Ultimate Protection Inc *Universal Pictures International *Union of Italian Provinces (Union of the Province d Italy)… … Wikipedia
Active Directory — (AD) is a directory service created by Microsoft for Windows domain networks. It is included in most Windows Server operating systems. Server computers on which Active Directory is running are called domain controllers. Active Directory serves as … Wikipedia
Oracle Forms — is a software product for creating screens that interact with an Oracle database. It has an IDE including an object navigator, property sheet and code editor that uses PL/SQL. It was originally developed to run server side in character mode… … Wikipedia
LabVIEW — Infobox Software name = LabVIEW caption = developer = National Instruments latest release version = 8.6 latest release date = August 4, 2008 operating system = Cross platform: [http://ni.com/labview/requirements Windows, Mac OS X, Linux] genre =… … Wikipedia