SQL> start a:13
SQL> set echo on
SQL> set verify off
SQL> set serveroutput on
SQL> --
SQL> -- joseph speigle
SQL> -- lab 13
SQL> -- PL half of PL/SQL class
SQL> -- July 22, 2002
SQL> --
SQL> --
SQL> -- problem one
SQL> --
SQL> -- create a package which includes two procedures and a single function
SQL> -- function: enter_student
SQL> -- procedures: insert_mylist, delete_mylist
SQL> CREATE OR REPLACE PACKAGE school_info IS
  2  FUNCTION
  3  	     enter_student(i_id IN NUMBER, i_lname IN VARCHAR, i_fname IN VARCHAR,
  4  i_age IN NUMBER) return varchar2;
  5  PROCEDURE
  6  	     insert_mylist(i_id IN NUMBER, i_lname IN VARCHAR, i_fname IN VARCHAR,i_age IN NUMBER);
  7  PROCEDURE
  8  	     delete_mylist(i_id IN NUMBER);
  9  END school_info;
 10  --
 11  --
 12  --
 13  .
SQL> /

Package created.

SQL> 
SQL> spool off