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.

## Contents

* 1 Overview
* 2 UPI-based applications
* 3 UPI-Based Libraries
* 4 External links
* 5 References

## 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

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

## References

1. ↑ Achacoso, Robwert (December 2009). Oracle Database Net Services Administrator's Guide 11g Release 2 (11.2). Oracle Corporation. http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/glossary.htm#BGBFHHJG. 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."

0.00

(0 votes)

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:User_Programmatic_Interface&oldid=3898795"