User Programmatic Interface
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
.
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)
aspect of the Oracle Client software stack.
C (programming language)
C is a general-purpose computer programming language developed between 1969 and 1973 by Dennis Ritchie at the Bell Telephone Laboratories for use with the Unix operating system....
-language software APIs
Application programming interface
An application programming interface is a source code based specification intended to be used as an interface by software components to communicate with each other...
which provide the lowest-level API-based interface to the Oracle database
Oracle database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
.
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/SQLPL/SQL
PL/SQL is Oracle Corporation's procedural extension language for SQL and the Oracle relational database...
or SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
to query, access, and manipulate data. The UPI library, an undocumented API used internally by Oracle, deals directly with the Two-Task Common (TTC)
aspect of the Oracle Client software stack.
UPI-based applications
Several Oracle database applications depend on UPI, including:- Oracle FormsOracle FormsOracle 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 terminal sessions. It was ported to other...
- 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 FormsAPIOracle FormsOracle 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 terminal sessions. It was ported to other...
- The Oracle Call InterfaceOracle Call InterfaceIn computing, the Oracle Call Interface consists of a set of C-language software APIs which provide an interface to the Oracle database....
Library - Oracle's SQLLIB (used by Oracle's Embedded SQLEmbedded SQLEmbedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code of the host language. The embedded SQL statements are parsed by an embedded...
Precompilers)