how to pack the trigger into the package

From: <magicmas_at_spymac.com>
Date: 31 Oct 2005 05:50:17 -0800
Message-ID: <1130766617.099753.289470@g47g2000cwa.googlegroups.com>

hi,

   i created a package which contain 3 trigger

---

create or replace package comp224_triggers AS

   trigger triggerOrderItemCreate;
   trigger triggerInventoryUpdate;
   trigger triggerAdjustStock;
END comp224_t

---

and i define the trigger like:

---

create or replace trigger triggerOrderItemCreate

	after insert on OrderItem
	for each row
declare
	l_msg varchar2(100);
begin
	l_msg := 'OrderItem created for '|| :new.orderid || ' item= ' ||

:new.itemid || ' , qty= '|| :new.quantity;

        insert into Journal(progUser, progTerminal, journalDate, tabName, message)

		values( user, USERENV('TERMINAL'), sysDate, 'OrderItem', l_msg);
	dbms_output.put_line(l_msg);

end triggerOrderItemCreate;
/

---

it can be complied in sql>

but i have no idea how to put it back in the the package comp224_triggers body

i tried to do like procedure and function, but it doesnt work

any one have idea ,,thanks a lot Received on Mon Oct 31 2005 - 07:50:17 CST