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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
