Anyone whom could explain this?

From: <roland.skoldblom_at_ica.se>
Date: Thu, 03 Apr 2003 02:08:53 -0800
Message-ID: <F001.005791CA.20030403020853@fatcity.com>

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). Received on Thu Apr 03 2003 - 04:08:53 CST