User Programmatic Interface

From Wikipedia, the free encyclopedia

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.

Contents 1 Overview 2 UPI-Based Applications 3 UPI-Based Libraries 4 External links

[edit] 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.

[edit] UPI-Based Applications

Several libraries are based on top of UPI, including:

• Oracle Forms
• SQL*Plus (also uses OCI)
• Oracle's IMP/EXP Utilities

[edit] 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)

[edit] External links

• Oracle SQL*Net Overview (includes basic UPI information)