Re: how to pack the trigger into the package

From: Tony Andrews <andrewst_at_onetel.com>
Date: 31 Oct 2005 06:11:06 -0800
Message-ID: <1130767866.253726.13640@o13g2000cwo.googlegroups.com>

magicmas_at_spymac.com wrote:
> i created a package which contain 3 trigger
> ------------------------------------------
> create or replace package comp224_triggers AS
> trigger triggerOrderItemCreate;
> trigger triggerInventoryUpdate;
> trigger triggerAdjustStock;
> END comp224_t
> ------------------------------------------
...

Triggers don't go inside pacakages at all. That package you created will be marked as INVALID. Run "show errors package comp224_triggers" and you will see something like this:

LINE/COL ERROR

---

---

2/12 PLS-00201: identifier 'TRIGGERORDERITEMCREATE' must be declared

2/12     PL/SQL: Declaration ignored
3/12     PLS-00201: identifier 'TRIGGERINVENTORYUPDATE' must be
declared
3/12     PL/SQL: Declaration ignored
4/12     PLS-00201: identifier 'TRIGGERADJUSTSTOCK' must be declared
4/12     PL/SQL: Declaration ignored

Received on Mon Oct 31 2005 - 08:11:06 CST