
	stored procedure


	Home > Oracle Database / Applications Definitions - Stored procedure

SearchOracle.com Definitions (Powered by WhatIs.com)

EMAIL THIS

LOOK UP TECH TERMS		Powered by:

Browse tech terms alphabetically:

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

stored procedure

Digg This!

StumbleUpon

Del.icio.us

- In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).

Getting started with stored procedure

To explore how the stored procedure is used in the enterprise, here are some additional resources:

Command to view stored procedure: Learn the data dictionary views you can use to view a stored procedure.

Error when calling stored procedure: Why is a user getting the ORA-06550 error when calling a stored procedure? Find the answer here.

Fast Guide: PL/SQL: Read the section on "working on stored procedures" in this PL/SQL guide. Get tutorials, tips and expert advice for working with PL/SQL stored procedures.

SQL Server stored procedures tutorial: Write, tune and get examples: This SQL Server stored procedure tutorial shares basics on how to write stored procedures, tune stored procedures, and browse stored procedure examples.

FAQ: SQL Server stored procedure how-tos: Write and run SQL Server stored procedures more effectively with this collection of FAQs.

Top five T-SQL stored procedures: From finding columns and tables to executing code from a file, these top five stored procedures will offer the simple tricks you need to get routine tasks done.

LAST UPDATED:

27 Oct 2008

Read more about stored procedure:

-	Search400.com has hundreds of links related to stored procedure.

Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Using the SQL GROUP BY clause for counting combinations Read SQL expert Rudy Limeback's advice for counting combinations in a table with SQL's GROUP BY clause
	How to use an SQL CASE expression Read an example of an SQL case expression from our SQL expert Rudy Limeback.
	How to use the Oracle Database SQL Reference Manual In this chapter, learn how to use the Oracle Database SQL Reference Manual, a collection of technical information on the SQL statements that work with...

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

autonomous transaction (SearchOracle.com)

CFML (SearchOracle.com)

Research Abstracts - stored procedure Articles

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy