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
170 Minutes

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.


    • Course Number: 216563_eng