Oracle-L: RE: Anyone whom could explain this?

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 03 Apr 2003 08:28:44 -0800
Message-ID: <F001.00579716.20030403082844@fatcity.com>

Things like :new.value and :old.value are commonly associated with the beasts called "triggers". You can find triggers on oracle tables and guns. For the rest, please read the fine manual.

-----Original Message-----
Sent: Thursday, April 03, 2003 5:09 AM
To: Multiple recipients of list ORACLE-L

Hallo,

anone whom could explain what new. means in this pl/sql procedure.

for instance: new.kundeoms := new.kundeoms + (in_diff);

                  new.mva := new.mva + (in_diff_mva);

How do I get hold of it so i can see which sql it runsor is new.kundeoms just a value from a table?

PROCEDURE add_kundeoms(in_diff in number, in_diff_mva in number,

                                       in_diff_brtkr in number, in_flagg in
varchar2) IS
            lDetaljFunnet boolean;
      BEGIN

            IF  in_flagg = '0' THEN
                  new.kundeoms := new.kundeoms + (in_diff);
                  new.mva := new.mva + (in_diff_mva);
                  new.kostverdi := new.kostverdi + (in_diff - in_diff_mva -
in_diff_brtkr);
            ELSIF in_flagg = '1' THEN
                  new.utg_pant := new.utg_pant + (in_diff);
            ELSIF in_flagg = '9' THEN
                  new.shop_in_shop := new.shop_in_shop + (in_diff);
            ELSIF   in_flagg = '5' THEN
                  new.rest_oms := new.rest_oms + (in_diff);
            END IF;

            BEGIN
                  db_dagoms_detalj.find(new.dagoms_id, in_flagg);
                  lDetaljFunnet := TRUE;
            EXCEPTION
                  WHEN OTHERS THEN
                        lDetaljFunnet := FALSE;
            END;
            IF lDetaljFunnet THEN
                  db_dagoms_detalj.edit;
                  db_dagoms_detalj.add_kundeoms(in_diff, in_diff_mva,
in_diff_brtkr);
                  db_dagoms_detalj.modify;
                  db_dagoms_detalj.close;
            END IF;
      END;

END; Thanks in advance

Roland

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: roland.skoldblom_at_ica.se

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gogala, Mladen
INET: MGogala_at_oxhp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------