Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

SQL> 
SQL> select title from episodes where title like '%1329%';

TITLE
--------------------------------------------------------------------------------
Episode 1329

SQL> select episodeTitle from featuring where episodeTitle like '%1329%';

EPISODETITLE
--------------------------------------------------------------------------------
Episode 1329

SQL> @proc2;

Procedure dropped.

  1  CREATE PROCEDURE k(
  2  	x episodes.title%TYPE,
  3  	y episodes.seriesCreator%TYPE,
  4  	z episodes.seriesTitle%TYPE)
  5  AS
  6  BEGIN
  7  	DELETE FROM episodes
  8  	WHERE title = x AND seriesCreator = y AND seriesTitle = z;
  9  	DELETE FROM featuring
 10  	WHERE episodeTitle = x AND seriesCreator = y AND seriesTitle = z;
 11* END k;

Procedure created.

  1  BEGIN
  2  	k('Episode 1329','creator107','series107');
  3* END;

PL/SQL procedure successfully completed.

SQL> select title from episodes where title like '%1329%';

no rows selected

SQL> select episodeTitle from featuring where episodeTitle like '%1329%';

no rows selected

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
2:40pm elaine35:~/cs145/hw5>