Evening Workshop
 
Home

Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions

DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance

Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers

Applications Series
E-Business Suite

Fusion Middleware Series
Oracle Application Server
Oracle Identity Management

Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi

Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures

 		 
11g Exception Handling
Ever since Oracle version 6 triggers and 7 procedures we have been writing PL/SQL. And every time we write a PL/SQL block we must consider appropriate exception handling. Both Oracle's exceptions and exceptions that might be specific to our application's functionality.

This 3 hour hands-on workshop has something for everyone from those writing their first exception handler to those who have been writing PL/SQL for more than a decade. Look at the list of topics, below, to see how this workshop might be valuable to you. All evening workshops are only $100/person.
For beginning and intermediate developers:
  • WHEN OTHERS THEN
  • Trapping Named Exceptions
  • SQLCODE and SQLERRM environment variables
  • Creating user defined exceptions
  • RAISE and RAISE_APPLICATION_ERROR
  • Using Locator Variables

For advanced developers and DBAs:

  • Naming Exceptions with PRAGMA EXCEPTION_INIT
  • Triggers that fire when on granting and revoking of privileges
  • Using DBMS_APPLICATION_INFO to SET and GET module and ACTION variables
  • An introduction to formatting call and error stacks
 
2007-2008 Calendar
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
 
Syllabus
5:45-6:00pm Introductions Join us for coffee before class begins.

To attend a workshop you must register at least one day in advance.
6:00-7:00pm Lab 1 Exception Handling Basics
Lab 1 is instructor lab in which we write basic PL/SQL procedures and functions and learn to generate and trap named exceptions, work with the SQLCODE and SQLERRM environment variables, and how to determine where errors have occurred using locator variables. Students build a basic exception logging system for use with both stand-alone and RAC databases.
7:30-8:00pm Lab 2 User Defined Exception
It is important to trap and log exceptions when Oracle's rules are violated. It is equally important to trap and log exceptions specific to an application. For example it is not permitted to take money from a bank ATM when the account balance is 0.

This lab teaches the techniques for declaring your own named exceptions  and trapping them. An essential part of this lab will be learning to work with PRAGMA EXCEPTION_INIT.
8:00-9:00pm Instructor
Demo		 Advanced Exception Handling
This section is a combination of lecture and instructor demo in which students learn how to apply a number of built-in techniques and packages including DBMS_APPLICATION_INFO and DBMS_UTILITY to greatly enhance the power of exception handlers.

If you have yet to write code with FORMAT_CALL_STACK, FORMAT_ERROR_BACKTRACE, FORMAT_ERROR_STACK, and WHOCALLEDME you won't want to miss this opportunity.
 
Instructors
Jack Cline is the chairman of the Puget Sound Oracle Users Group and has done Oracle contract work in the Puget Sound area for the past 11 years including engagements at Boeing, Bank of America, King County, the City of Seattle, Puget Sound Energy, and the Seattle-King Country Department of Health. He is a frequent guest lecturer at the University of Washington's Oracle Certification Program.
Dan Morgan Dan Morgan is an Oracle Ace Director, a 10g and 11g Beta tester for Oracle, and the instructor of the Oracle program at the University of Washington since its inception in 1999. He began his IT career in 1969 with an IBM 370/145, punch cards, and Fortran IV, and though he will vigorously deny it, wrote COBOL for a decade before moving into Oracle about when version 6 hit the market.

In addition to Dan's work at the university he is the Education Chair of the Puget Sound Oracle Users Group, a member of UKOUG, and a member of the British-American Chamber of Commerce in Seattle. He is also a frequent lecturer at training events and at conferences and has presented at Oracle OpenWorld on RAC (2005), at Seattle OracleDay (2004-2007), at numerous government and corporate training events including Apple Computer, Argonne National Laboratory, Boeing Commercial Airplane Group, Dow Jones & Company, Lawrence Livermore National Laboratory, NASA, T-Mobile, US Navy at Pearl Harbor, and Weyerhaeuser to name but a few and presented on Streams and Change Data Capture at UKOUG in 2006.

Dan Morgan is the Morgan behind the "Morgan's Library" website that contains the many demos he has  created for his University of Washington classes as well as for his frequent lectures. He is the former publisher of MacTech Journal, has presented Oracle technical lectures in the US, Canada, Great Britain, and Japan. Morgan is also the author of this course.
Caleb Small is the primary instructor for the Oracle Workforce Development program at Camosun College in Victoria BC, and a private consultant with years of experience implementing and teaching Oracle throughout North America. He has over 30 years experience in the IT industry in numerous business areas including both public and private sectors.

Caleb is also active as a director of the Victoria and Puget Sound Oracle User Groups, and has delivered numerous lectures, presentations, live demos and articles to other groups.  He has authored and led many of the PSOUG workshops including RAC, ASM, RMAN and Data Guard.

Caleb was one of the first people to build an 11g RAC cluster and has been a primary consultant on RAC to publicly held corporations including Areva T&D and Montana Dakota Utilities (MDU).
 
This is site maintained by the Puget Sound Oracle Users Group. Last Updated: