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 Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online t ...

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) 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 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 sy ...

Library * Oracle's SQLLIB (used by Oracle's

Embedded SQL Embedded SQL is a method of combining the computing power of a programming language and the database Data Manipulation Language, manipulation capabilities of SQL. Embedded SQL statement (programming), statements are SQL statements written inline wi ...

Precompilers)

External links

Oracle SQL*Net Overview (includes basic UPI information)

References

Oracle software {{database-software-stub