Murach's Oracle SQL and PL/SQL
How to create stored procedures and functions

This chapter shows you how to code two types of database objects that store PL/SQL code within a database for execution by anyone using the database: stored procedures and user-defined functions.
Chapter 15 How to create stored procedures and functions
How to code stored procedures 462
How to create and call a stored procedure 462
How to code input and output parameters 466
How to code optional paramaters 468
How to raise errors 470
A stored procedure that inserts a row 474
A stored procedure that drops a table 478
How to drop a stored procedure 480
How to code user-defined functions 482
How to create and call a function 482
A function that calculates balance due 484
How to drop a function 486
How to work with packages 488
How to create a package 488
How to drop a package 490
Advantages of packages 490
How to use SQL Developer 492
How to view and drop procedures, functions, and packages 492
How to edit and compile procedures and functions 494
How to grant and revoke privileges 494
How to debug procedures and functions 496


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.