alias handin8711 /export/home/csc8711/bin/handin

handin8711 1 file1 file2 etc

IMPORTANT NOTE FOR ASSIGNMENT 1: My grader plans to execute YOUR CODE on HER DATA. To make this possible you need to do three things:

1. You have to give EXECUTE priveleges to Oracle users raj (instructor) and cscycwx (grader) using the following commands:

   SQL> grant execute on procedure/package to raj;
   SQL> grant execute on procedure/package to cscycwx;
   

   for all your procedures and packages. If you put all code inside a package (strongly recommended), you will have to grant the privilege only once for the package.
2. You have to use the phrase "authid current_user" next to the procedure/package definition as follows:

     create or replace package bboard authid current_user is
   or
     create or replace procedure p1 authid current_user is
   

   Once again, if you put all code within a package, you have to do this only once, for the package specification.
3. Make sure that ALL your procedure and function calls are prefixed by your Oracle user id as follows:

      htp.formOpen(owa_util.get_owa_service_path || 
                    'cscxxxx.bboard.procedure1', 'POST', 'display_window');
   

   Your procedure calls are typically within htp.formOpen, with HTML form tags, and sometimes with SQL queries, or within your code. Please make sure all procedure calls are covered.