Oracle database packages, procedures, functions, and triggers: When and how to use them

PDF Version Also Available for Download.

Description

With Oracle7, application developers and database administrators have been given the means to store and reference procedural logic within the database itself. Used appropriately, these tools allow database developers to significantly enhance the capabilities of Oracle applications and operations. This paper examines the structure and use of these tools, and offers some guidelines to assist users in applying the tools to typical development problems. First, the advantages and disadvantages of implementing application logic within the database is discussed, as opposed to the traditional approach that codes application logic within end-user tools. Next, the specific syntax and construction of these database ... continued below

Physical Description

20 p.

Creation Information

Ress, F. December 1995.

Context

This article is part of the collection entitled: Office of Scientific & Technical Information Technical Reports and was provided by UNT Libraries Government Documents Department to Digital Library, a digital repository hosted by the UNT Libraries. More information about this article can be viewed below.

Who

People and organizations associated with either the creation of this article or its content.

Author

Sponsor

Publisher

Provided By

UNT Libraries Government Documents Department

Serving as both a federal and a state depository library, the UNT Libraries Government Documents Department maintains millions of items in a variety of formats. The department is a member of the FDLP Content Partnerships Program and an Affiliated Archive of the National Archives.

Contact Us

What

Descriptive information to help identify this article. Follow the links below to find similar items on the Digital Library.

Description

With Oracle7, application developers and database administrators have been given the means to store and reference procedural logic within the database itself. Used appropriately, these tools allow database developers to significantly enhance the capabilities of Oracle applications and operations. This paper examines the structure and use of these tools, and offers some guidelines to assist users in applying the tools to typical development problems. First, the advantages and disadvantages of implementing application logic within the database is discussed, as opposed to the traditional approach that codes application logic within end-user tools. Next, the specific syntax and construction of these database objects is examined. Some suggestions are offered on how to determine which tool, or combination of tools, to use in a given situation, and some tips on error handling and debugging are presented.

Physical Description

20 p.

Notes

OSTI as DE96004825

Source

  • International Oracle User Week conference, Philadelphia, PA (United States), 18-22 Sep 1995

Language

Item Type

Identifier

Unique identifying numbers for this article in the Digital Library or other systems.

  • Other: DE96004825
  • Report No.: ANL/ASD/CP--87461
  • Report No.: CONF-9509249--2
  • Grant Number: W-31109-ENG-38
  • Office of Scientific & Technical Information Report Number: 188619
  • Archival Resource Key: ark:/67531/metadc669526

Collections

This article is part of the following collection of related materials.

Office of Scientific & Technical Information Technical Reports

What responsibilities do I have when using this article?

When

Dates and time periods associated with this article.

Creation Date

  • December 1995

Added to The UNT Digital Library

  • June 29, 2015, 9:42 p.m.

Description Last Updated

  • Dec. 18, 2015, 4:15 p.m.

Usage Statistics

When was this article last used?

Yesterday: 0
Past 30 days: 0
Total Uses: 5

Interact With This Article

Here are some suggestions for what to do next.

Start Reading

PDF Version Also Available for Download.

Citations, Rights, Re-Use

Ress, F. Oracle database packages, procedures, functions, and triggers: When and how to use them, article, December 1995; Illinois. (digital.library.unt.edu/ark:/67531/metadc669526/: accessed September 25, 2017), University of North Texas Libraries, Digital Library, digital.library.unt.edu; crediting UNT Libraries Government Documents Department.