Creating Stored Procedures and Functions

Overview/Description
To create and execute a stored function and call, and remove and view stored functions in PL/SQL

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
2.8

Lesson Objectives

Creating Stored Procedures and Functions

create, remove, and view PL/SQL stored procedures.

use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs.

outline how to view values returned by OUT parameters.

create stored procedures with suitable parameters.

assign values to multiple parameters in a stored procedure and invoke that procedure.

handle exceptions in stored procedures.

execute a stored procedure in which you have assigned parameter values and handled exceptions.

create and execute a stored function.

call, remove, and view stored functions in PL/SQL.

create, call, and remove stored functions in PL/SQL.