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.
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 applicationsedit
Several Oracle database applications depend on UPI, including:
^ Achacoso, Robwert; et al. (December 2009). Oracle Database Net Services Administrator's Guide 11g Release 2 (11.2). Oracle Corporation. 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.
This database software-related article is a stub. You can help Wikipedia by expanding it.
user, programmatic, interface, this, article, needs, additional, citations, verification, please, help, improve, this, article, adding, citations, reliable, sources, unsourced, material, challenged, removed, find, sources, news, newspapers, books, scholar, jst. This article needs additional citations for verification Please help improve this article by adding citations to reliable sources Unsourced material may be challenged and removed Find sources User Programmatic Interface news newspapers books scholar JSTOR January 2014 Learn how and when to remove this message The topic of this article may not meet Wikipedia s general notability guideline Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention If notability cannot be shown the article is likely to be merged redirected or deleted Find sources User Programmatic Interface news newspapers books scholar JSTOR January 2014 Learn how and when to remove this message 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 ReferencesOverview editUPI 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 editSeveral Oracle database applications depend on UPI including Oracle Forms SQL Plus also uses OCI Oracle Corporation s data import and export IMP EXP utilitiesUPI Based Libraries editSeveral 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 editOracle SQL Net Overview includes basic UPI information References edit Achacoso Robwert et al December 2009 Oracle Database Net Services Administrator s Guide 11g Release 2 11 2 Oracle Corporation 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 nbsp This database software related article is a stub You can help Wikipedia by expanding it vte Retrieved from https en wikipedia org w index php title User Programmatic Interface amp oldid 1024337842, wikipedia, wiki, book, books, library,
