POST-CHANGE Trigger [message #435041] |
Mon, 14 December 2009 00:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rkgoyal98
Messages: 39 Registered: October 2009
|
Member |
![rkgoyal_98](/forum/theme/orafaq/images/yahoo.png)
|
|
Hello,
I have follwing code on post-change trigger on :currentread item
DECLARE
V_AMT NUMBER;
V_CONS NUMBER;
V_MONTHS NUMBER;
V_RULE VARCHAR2(2000);
V_SQL VARCHAR2(2000);
BEGIN
V_AMT:= 0;
IF :UPDATEKEY = 'Y' OR :UPDATEKEY IS NULL THEN
IF :BLK_PRTRQTRELDTL.PREVIOUSREAD IS NOT NULL THEN
IF :BLK_PRTRQTRELDTL.CURRENTREAD IS NOT NULL THEN
V_CONS := 0;
V_MONTHS := (MONTHS_BETWEEN(TO_DATE(TO_CHAR((:TODATE),'RRRRMM'),'RRRRMM'),
TO_DATE(TO_CHAR(:FROMDATE,'RRRRMM'),'RRRRMM')))+1;
V_CONS := ROUND((:BLK_PRTRQTRELDTL.CURRENTREAD-:BLK_PRTRQTRELDTL.PREVIOUSREAD)/V_MONTHS,0);
V_AMT := PRIME.cal_elecamt(:STATE,:BLK_PRTRQTRELMAS.QUARTERTYPE,:FROMDATE,:TODATE,V_MONTHS,V_CONS);
:CURRENTAMT := V_AMT;
END IF;
END IF;
END IF;
END;
This code is working fine whenever there is change of :currentread data. However everytime new form is opened it gives an error
FRM - 40735 : post-change trigger raised and unhandled exception ORA-01403.
After clicking okay on the alert box data from the query is populated in the form and it works fine.
Kindly help me in how to avoid this error
Regards
[Updated on: Mon, 14 December 2009 00:31] Report message to a moderator
|
|
|
|
|
|
|