Database Development

Lab Assignment 4 - (b1,c1)

A. Analyze the package in Q2, and draw a diagram for it, analyze how you will build and call it. [5 marks] c1

B. Write PL/SQL code to create package called CSC325_PACKAGE that use the function and procedure that you create them in Assignment1 in addition to one more function and one more procedure of your choice. Show the usage of the package procedures and function. You need to use one exception( Oracle exception or user exception) [5 marks]- b1

• You have to attach with this file:
  • Source Code
  • Screenshots of the execution results

Q1. Write PL/SQL code to create package called CSC325_PACKAGE that use the function and procedure that you create them in Assignmentl in addition to one more function and one more procedure of your choice. Show the usage of the package procedures and function. You need to use one exception( Oracle exception or user exception) [5 marks]- b1 Q1. Write PL/SQL code to create package called CSC325_PACKAGE that use the function and procedure that you create them in Assignmentl in addition to one more function and one more procedure of your choice. Show the usage of the package procedures and function. You need to use one exception( Oracle exception or user exception) [5 marks]- b1