Database Tutorial

Course Tutorial Site

Site Admin

CIT325: Lab 6 Instructions

without comments

Lab #6: Oracle Assignment


The lab is designed to teach you how to work with cursor loops, SQL collections, and an UPDATE statement in a range for loop. You will write an anonymous block PL/SQL program that should achieve these objectives:

  • Learn how to work user error handling.
  • Learn how to log errors to a table, to manage an error stack.
  • Learn how to work with stored procedures – inline and autonomous transactions.
  • Learn how to call stored procedures.

Business Scenario

Application programs should contain meaningful error handling. The error handling should ideally return an error stack that helps Support Analysts narrow the scope of a problem when one occurs.

This lab shows programmers how to create a stored procedure that captures and logs errors in a stack. A stack is a first-in and last-out (FILO) queue. The stack is stored in a table that lets you return it in any order but you can return it in a last out format by leveraging the surrogate key column and an ORDER BY clause.

Help Section

The following is an set of sample programs and steps that address concepts in the lab. The instructor should review these in classroom or in a Google Hangout with students. Click the Instructional Material link to see the preparation lesson material.

Students may want or need supplemental articles that let them review tips and techniques. The following is a function that checks for valid dates inside strings. You should run this type of check after you rule out a number and alphanumeric string.

The lab has one part.

Lab Description

[25 points] Click the Lab Instructions link to open the instructions inside the current webpage.

Test Case

Click the Test Case Instructions link to open the test case instructions inside the current webpage.

Written by michaelmclaughlin

December 15th, 2016 at 11:33 am

Posted in