PLS-00382 error in Trigger

From: Kelly Gallagher <kelly_gallagher_at_unc.edu>
Date: Thu, 9 Sep 1999 13:45:31 -0400
Message-ID: <7r8rnl$rv7$1_at_fddinewz.oit.unc.edu>



Hello,

[Quoted] I'm a newbie, trying to create a trigger (actually two triggers since I need to avoid the mutating table error). I am working from Oracle8 PL/SQL Programming, 1997, pages 337 and 338. Any suggestions as to why I am getting this damn PLS-00382 error are most welcome; I just can't seem to figure it out. Thanks !

The SQL sessions:

  SQL> CREATE OR REPLACE PACKAGE ih_fumehoodinsphist_data AS   2
  3 TYPE t_Hood_Nums IS TABLE OF ih_tb_fumehoodinsphist.hood_num%type   4 INDEX BY BINARY_INTEGER;
  5
  6 v_FumeHoodInspHistHood_Nums t_Hood_Nums;   7
  8 END ih_fumehoodinsphist_data;
  9 /

Package created.

SQL> CREATE OR REPLACE TRIGGER Rih_fumehoodinsphist_Insert   2 BEFORE INSERT ON ih_tb_fumehoodinsphist   3 FOR EACH ROW
  4 BEGIN
  5
  6 ih_fumehoodinsphist_data.v_FumeHoodInspHistHood_Nums := :new.hood_num;   7
  8 END Rih_fumehoodinsphist_Insert;
  9 /

Warning: Trigger created with compilation errors.

SQL> show errors
Errors for TRIGGER RIH_FUMEHOODINSPHIST_INSERT:

LINE/COL ERROR

-------- -----------------------------------------------------------------
[Quoted] 3/2      PL/SQL: Statement ignored
3/58     PLS-00382: expression is of wrong type
SQL> Received on Thu Sep 09 1999 - 19:45:31 CEST

Original text of this message