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

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”