Stored Procedure Overview :
Stored Procedure Overview Stored Procedure is a function in a shared library accessible to the database server
Slide 3:
Applications using stored procedures
Writing Stored Procedures :
Writing Stored Procedures CREATE OR REPLACE PROCEDURE <name> (<arglist>) AS <declarations>
BEGIN
<procedure statements>
END
Explicit parameter to be defined :
IN: Passes a value to the stored procedure from the client application
OUT: Stores a value that is passed to the client application when the stored procedure terminates.
INOUT : Passes a value to the stored procedure from the client application, and returns a value to the Client application when the stored procedure terminates
Slide 5:
Some Valid SQL Procedure Body Statements
CASE statement
FOR statement
GOTO statement
IF statement
ITERATE statement
RETURN statement
WHILE statement
Slide 6:
Advantages Of Stored Procedures :
Advantages Of Stored Procedures Precompiled execution.
Reduced client/server traffic
Efficient reuse of programmed code and programming concept.
Better security controls
summary :
summary Stored Procedure Overview
Writing Stored Procedures
Some Valid SQL Procedure Body Statements
Example for Valid Stored Procedure
Advantages Of Stored Procedures
Slide 9:
THANK YOU