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

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Thu, 03 Apr 2003 03:58:42 -0800
Message-ID: <F001.005792C0.20030403035842@fatcity.com>

Is this procedure being run with a trigger Roland?

If so then the :new refers to the value of each row that is being inserted from the table

To explain better

if an update triggger is on table roland with columns (road,town,country) and one row is in the table with values Main Rd, Leeds, England and the row is being updated to be New_Main Rd, Leeds, England then the following values will be in place

old:road  = Main Rd   new:road  = New_Main Rd
old:town = Leeds new:town=Leeds
old:country = England new:country=England.

That is about 100% of my PL/SQL knowledge so I hope I am correct

John

-----Original Message-----
Sent: 03 April 2003 11:09
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: Hallas, John, Tech Dev
INET: John.Hallas_at_gb.vodafone.co.uk

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