xyz

• Oct 20th, 2005

 

Stored Procedure is the PlSQL subprgram stored in the databasse .

Kavitha Sengottaiyan

• Jan 27th, 2006

 

Stored Procedure

A program running in the database that can take complex actions based on the inputs you send it. Using a stored procedure is faster than doing the same work on a client, because the program runs right inside the database server. Stored procedures are nomally written in PL/SQL or Java.

Like to become an Oracle geek

• May 22nd, 2007

 

A stored procedure is a subprogram that is stored in the database as a PCODE and thus called as a standalone schema object.

a) It can be invoked directly from any calling environments, or other subprograms.

b) It is similar to any subprogram that accepts parameters and performs an action. It may or may not return a value. This attribute differentiates it from another subprogram type called FUNCTION.

c) It can be nested

d) Is created by using the syntax CREATE OR REPLACE

e) This stored procedure can be seen as an object in the User_Objects and is different from the procedures that are created in packages.

ramesh_resides

 Profile Answers by ramesh_resides 

• Jun 23rd, 2007

 

Stored procedure is a sub program and stored in memory for repated execution

g_sidhu

 Profile 

• Jan 31st, 2008

 

A procedure is a named PL/SQL block that can accept parameters (sometimes referred to as arguments), and be invoked. Generally speaking, you use a procedure to perform an action. A procedure has a header, a declaration section, an executable section, and an optional exceptionhandling section.

A procedure can be compiled and stored in the database as a schema object.

Procedures promote reusability and maintainability. When validated, they can be used in any number of applications. If the requirements change, only the procedure needs to be updated.