Re: help me pls

From: World Cup Fishing <webmaster_at_worldcupfishing.com>
Date: Tue, 6 Mar 2001 00:09:22 -0700
Message-ID: <yZ9p6.3006$tn1.29492@news1.mts.net>

Try using bind variables. I think you're looking for something like this....

begin

                if updating then
                    :new.modified_by := user;
                    :new.date_modified := sysdate;
                end if;
                if inserting then
                    :new.created_by := user;
                    :new.date_created := sysdate;
                end if;

end;

hth,

Joe Ranseth

"C.K." <cklok2000_at_sinaman.com> wrote in message news:9837ed$jng$1_at_charm.magnus.acs.ohio-state.edu...
> i really need some help on this,
>
> i'm trying to fire a trigger after/before(this doesn't matter) i insert a
> record into the database.
> The problem is that, during the time of running the trigger, i have to add
> some data to the inserting record; like.. the time of insert, something
like
> that.
> i know that using a temp table, and run the trigger thru the insert of
temp
> table will be easier, however, due to some restriction, i can't do that,
can
> anybody tell me a better way so that i can edit the data while i'm
inserting
> it to the table?
> pls help me out!
>
>
>
Received on Tue Mar 06 2001 - 01:09:22 CST