SEO

#1 (**permalink**) 02-24-2008, 05:23 PM

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

#2 (**permalink**) 02-24-2008, 05:24 PM

magicmas@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

#3 (**permalink**) 02-24-2008, 05:24 PM

Trigger != Stored Procedure. Trigger not valid for Package.

By reading docco, you find you can replace trigger body with 'CALL
stored_procedure' which is in package.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting guarantees I will not respond further ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

how to pack the trigger into the package