xyz
Answered On : Oct 20th, 2005
Stored Procedure is the PlSQL subprgram stored in the databasse .
Login to rate this answer.
Kavitha Sengottaiyan
Answered On : 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.
Login to rate this answer.
Like to become an Oracle geek
Answered On : 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.
1 User has rated as useful.
Login to rate this answer.
Stored procedure is a sub program and stored in memory for repated execution
Login to rate this answer.
g_sidhu
Answered On : 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.
1 User has rated as useful.
Login to rate this answer.
