Creating Stored Procedures and Functions

This course is included in our On-demand training solution.


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


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 min.

Course 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.