New maybe a Package and the Variables may be Public variables.
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
-----Original Message-----
John, Tech Dev
Sent: Thursday, April 03, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hallas, John, Tech Dev
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ganesh Raja
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).
